Viewing 15 posts - 2,086 through 2,100 (of 3,348 total)
sestell1 (6/25/2012)
Does anyone know what SQL Server actually...
June 25, 2012 at 11:21 am
Haining (6/23/2012)
Should it be dependent on the version of SQL Server targeted on?(...)
This is contradicted to the later version SQL Server on Limitations and Restrictions for table variable. Reference: http://msdn.microsoft.com/en-us/library/ms175010%28v=sql.105%29.aspx
No,...
June 25, 2012 at 1:05 am
When I answered the question, I *knew* I was taking a gamble on the intended interpretation.
What convinced me to pick the "wrong" answer was the wording: "can have primary keys...
June 25, 2012 at 12:55 am
Robert-378556 (6/22/2012)
Any answer can be valid as anything unspecified can follow - any alter table, drop table, even drop database.It's like a question "Guess what I'm thinking about".
That's why I...
June 22, 2012 at 9:17 am
Lon-860191 (6/22/2012)
While the question was great, the answer was wrong, two versions back from 2012 is 2008 2005 is not supported accroding to your reference.Thanks for the question though.
You forget...
June 22, 2012 at 9:15 am
codebyo (6/22/2012)
This could be a useful code to set some fields from a a few restricted rows to some...
June 22, 2012 at 5:26 am
Koen Verbeeck (6/22/2012)
Very interesting question. I never use this syntax with the correlated subquery, so it would have been nice to give a bit more explanation on that.
Logically (actual execution...
June 22, 2012 at 3:14 am
Revenant (6/20/2012)
Koen Verbeeck (6/20/2012)
paul.knibbs (6/20/2012)
a kilobyte has always been 1024 bytes as far as I'm concerned.For me, a kilobyte is still 1000 bytes. kilo = 1000
Sure. If a prospective employer...
June 20, 2012 at 9:10 am
paul.knibbs (6/20/2012)
Hugo Kornelis (6/20/2012)
SQL Server itself does impose this limit. As specified at the link included in the explanation, SQL Server has a limitation of 32767 (the maximum value in...
June 20, 2012 at 7:31 am
Ernie Schlangen (6/20/2012)
June 20, 2012 at 7:05 am
tommyh (6/19/2012)
You can install 2012 on FAT32 and that have a limit to 4GB/file. The...
June 20, 2012 at 3:45 am
Sean Lange (6/19/2012)
Thomas Abraham (6/19/2012)
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
I suspect you actually use outer joins far more frequently...
June 19, 2012 at 7:56 am
dogramone (6/14/2012)
To all others that have read my previous post and feel...
June 14, 2012 at 5:32 pm
dogramone (6/14/2012)
If the questions had said other constraints AND indexes were being added then it was a no brained "it depends".
It is not possible to add indexes in a CREATE...
June 14, 2012 at 4:49 pm
venoym (6/14/2012)
June 14, 2012 at 12:05 pm
Viewing 15 posts - 2,086 through 2,100 (of 3,348 total)