Hi,
I've a Service utilising the Adapter EnsLib.SQL.InboundAdapter, which uses a Credentials item set with the details of a local SQL account. This currently works, however, we're looking to use the credentials of an AD domain account.
The domain account is a member of an AD security group, which has the required permissions on the source SQL database. I've checked that access is possible with this account via SQL studio.
hi,
i have two where-clauses:
a) ... WHERE company=1 and product=7
b) ... WHERE product=7 and company=1
with other words the position of the where fields are swapped.
now the question is:
bring the where clauses a) and b) the same performance(queryplan) or do i have to write it in a special order???
in my point of view, there is a parser/optimizer who cares about this, so i don't have to care about.
Hello,
I have a small SQL question.
Running an example queries in our Samples Namespace:
1. select top 5 Description,Category from Cinema.Film order by Category - runs fine no issues and returns 2 columns as expected
2. select top 5 * from Cinema.Film order by Category - runs fine no issues and returns 8 columns as expected
3. select top 5 Description,Category,* from Cinema.Film order by ID - runs fine no issues, and returns 10 columns, with my first 2 repeated
4. When I try to combine the first 2 queries:
.png)
To request a copy of the examples only – please see me, will email them out for free. pmkadow@gmail.com
