I like questions from which I learn

Hi all,

Interesting questions...also the following query:

SELECT id

FROM dbo.SalesDates s

WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the...

Hi all,

Interesting questions...also the following query:

SELECT id

FROM dbo.SalesDates s

WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the...

Hi all,

Interesting questions...also the following query:

SELECT id

FROM dbo.SalesDates s

WHERE '2012/1/03' IN (SELECT saledate FROM SalesDates);

is equivalent to the one given in the QotD. If you try for the...

Thank you Jared

I tried and succeed. I admit that my administration skills are not as good as my developing. However I'm working on it.

Actually, I can now conclude that the...

I got it right, but i managed myself by a sql-query from a c# code that was using date comparison without casting string-dates to sql-dates and it worked well. I...

No, I met this occasionally. It's inspired by practice.

Hi,

I agree with you.

From the reference

"If the value of test_expression/subquery is equal to any value returned by subquery or is equal to any expression from the comma-separated list, the...

Hi,

I agree with you.

From the reference

"If the value of test_expression/subquery is equal to any value returned by subquery or is equal to any expression from the comma-separated list, the...

Hi,

I agree with you.

From the reference

"If the value of test_expression/subquery is equal to any value returned by subquery or is equal to any expression from the comma-separated list, the...

Hi All,

I tried to make a conclusion based on the data type precedence, but did not manage.

If you see the data type precedence

http://msdn.microsoft.com/en-us/library/ms190276.aspx

, it is also ambiguous for...

Hi,

If you read the Restrictions on this link

http://msdn.microsoft.com/en-us/library/ms186388.aspx

you'll find that the model database cannot be set to read_only.

But, okey,

I should have tried it!, it is my mistake...

Hi,

If you read the Restrictions on this link

http://msdn.microsoft.com/en-us/library/ms186388.aspx

you'll find that the model database cannot be set to read_only.

But, okey,

I should have tried it!, it is my mistake...

Hi,

If you read the Restrictions on this link

http://msdn.microsoft.com/en-us/library/ms186388.aspx

you'll find that the model database cannot be set to read_only.

But, okey,

I should have tried it!, it is my mistake...