Viewing 15 posts - 1,921 through 1,935 (of 3,348 total)
Hi Tom,
You are right that there are indeed some issues with CASE. And I may not have remembered them all correctly. First, let's skip all older versions of the documentation...
December 23, 2012 at 3:52 pm
L' Eomot Inversé (12/22/2012)
But the explanation, as it refers to nullif and to view5, is a bit of a mess - it appears to say that view5 will always...
December 23, 2012 at 3:56 am
I have to offer my apologies for this question. I don't know what went wrong. I always check my question, answers and explanation several times before submitting, but I don't...
December 23, 2012 at 3:29 am
L' Eomot Inversé (12/20/2012)
dawryn (12/20/2012)
BTW found this request for unique constraint ANSI compliance regarding multiple null values
I greatly wish that a large number of people would pile in and downvote...
December 21, 2012 at 3:04 am
While I agree that the wording of the question is debatable (I chose my reply, and then was hoping I had second-guess the author's intention right), I also want to...
December 20, 2012 at 1:42 am
palotaiarpad (12/19/2012)
Could someone please explain, why is the identity resetted after a truncate?
Because conceptually, TRUNCATE TABLE is closer to DROP / CREATE than to DELETE.
December 19, 2012 at 4:40 am
L' Eomot Inversé (12/17/2012)
December 17, 2012 at 7:23 am
Rich Weissler (12/14/2012)
But, okay... I give up, how does having an indexed view cause a loss of precision?
(I.e. Yep, I see the error. I don't understand WHY. ...
December 14, 2012 at 8:41 am
Good question.
I am not sure why Lokesh chose to include a link to the SQL Server 2000 version of the documentation. Especially since the setup script uses SQL Server 2008...
December 13, 2012 at 4:34 am
antony-688446 (12/12/2012)
But Here http://msdn.microsoft.com/en-us/library/ms173454(v=sql.105).aspx (SQL 2008R2) its is...
Did MS re-classify GROUPING_ID as an aggregate function between...
December 12, 2012 at 3:31 pm
antony-688446 (12/11/2012)
Stewart "Arturius" Campbell (12/5/2012)
Interesting question, thanks.just bear in mind that GROUPING_ID only came into effect with SQL2008. Those still using 2005 will not have knowledge hereof...
Being pedantic, GROUPING_ID came...
December 12, 2012 at 7:13 am
Toreador (12/12/2012)
Hugo Kornelis (12/12/2012)
Using sp_rename to rename a programmability item does not change its definition in sys.sql_modules. That's why Books Online recommends to use DROP / CREATE instead.
I've never...
December 12, 2012 at 4:14 am
As happens more often with a Question of the Day: Good idea, but badly executed.
If you exactly follow the instructions, executing the 'alter proc' script after making the change will...
December 12, 2012 at 12:39 am
L' Eomot Inversé (12/6/2012)
That's still missing ij and IJ (maybe Hugo will tell us whether Dutch generally uses these ligatures or has generally switched to non-ligatured representation).
When I was young,...
December 6, 2012 at 4:33 pm
I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am surprised that...
December 6, 2012 at 5:32 am
Viewing 15 posts - 1,921 through 1,935 (of 3,348 total)