Viewing 15 posts - 1,696 through 1,710 (of 3,348 total)
crussell-931424 (6/13/2013)
June 13, 2013 at 7:14 am
Boy, how do I hate questions like this. No wait, the question is okay, it's the answer options.
If the question is "how many rows", the answer options should be numbers....
June 13, 2013 at 1:09 am
sknox (6/12/2013)
This means that the first query returns all rows from MyTable, the second only the rows with NumericColumn equal to...
June 12, 2013 at 11:53 am
Ford Fairlane (6/12/2013)
very "nasty" question missed it all together - lost in translation - between computer screen and my brain :p
Thanks! (Goes for the other replies as welll).
I was aware...
June 12, 2013 at 5:28 am
raulggonzalez (6/12/2013)
June 12, 2013 at 5:26 am
Louis Hillebrand (6/11/2013)
When I change the Compatibility level to 90 or 100 (SQL 2005 / 2008 )...
June 11, 2013 at 10:07 am
Louis Hillebrand (6/11/2013)
When I run the 2nd query it inserts 2 rows into the table.
Louis Hillebrand (6/11/2013)
The final select returns '10' and '2012-10-10'
That's very strange. I cannot reproduce this (SQL...
June 11, 2013 at 2:53 am
Louis Hillebrand (6/11/2013)
When I run the 2nd query it inserts 2 rows into the table.So my answer would be 'error', '2 rows', '2 rows'.
That's strange...
What is the data returned...
June 11, 2013 at 2:28 am
Good question. Too bad the explanation is lacking. It explains how to work around the issue, but not what causes it.
The answer to that is data type precedence. Both VALUES...
June 11, 2013 at 12:56 am
Srinivas.Pendyala (6/10/2013)
i cant understand that how the result will come,both are same that giving same outputcan please tell me the how it is possible
Hi Srinivas,
Sure! There's an excellent discussion about...
June 11, 2013 at 12:39 am
nenad-zivkovic (6/7/2013)
From BOL http://msdn.microsoft.com/en-us/library/ms187912(SQL.100).aspx
Avoid using float or real columns in WHERE clause search conditions, especially the = and <> operators.
Should be "Avoid using float or real columns." Period. Exclamation mark....
June 8, 2013 at 4:28 am
Danny Ocean (6/6/2013)
Can anybody give correct reason for this result ?
When working with decimal (base 10) fractions, most people easily understand this. If you use a fixed number of decimals...
June 8, 2013 at 3:34 am
eric larocca (6/7/2013)
this is like saying Length or 2 = Length of 1
in the problem it is small r + a blank space set...
June 7, 2013 at 2:34 pm
Joseph M. Morgan (6/6/2013)
June 6, 2013 at 1:25 pm
Neeraj Prasad Sharma (6/4/2013)
Please explain this
Select isnull ('A',1 ) does not return Error
select COALESCE( 'A', 1)
Conversion failed when converting...
June 4, 2013 at 2:01 am
Viewing 15 posts - 1,696 through 1,710 (of 3,348 total)