Viewing 15 posts - 46 through 60 (of 103 total)
Easy Question but great discussion about count(*) & inserting Null and also bit of knowledge about avg function from peter.
June 23, 2011 at 7:24 pm
Great Question Daniel, had to run it in SSMS to understand and get it right.
Learned something new.
June 23, 2011 at 7:17 pm
Carlo Romagnano (6/23/2011)
If the condition of the WHERE clause validates to true then the result set is returned. If it does not, the result set is empty.
This is true...
June 23, 2011 at 7:08 pm
Simple Question but discussion was so detailed that you learn a loads of thing from the discussion 😀
January 28, 2011 at 7:40 pm
I knew that Rank() skips the number if there is a tie but thought it's still consecutive number in a sense next available int number.
January 18, 2011 at 6:03 am
Nice one. I thought it right you can't update logical table.
January 18, 2011 at 5:59 am
I don't have access to SQL 2005 and i tried to run against 2008 and selected answers accordingly
January 18, 2011 at 5:57 am
Viewing 15 posts - 46 through 60 (of 103 total)