Viewing 15 posts - 631 through 645 (of 652 total)
bitbucket-25253 (10/1/2009)
the question was designed to bring attention to the subtle changes made between 2005 and 2008. Too many people fixated on the word (subclauses) and not enough paid...
October 2, 2009 at 2:17 am
The question was "SQL Server 2008 introduces several extensions (subclauses), to the GROUP BY clause"
GROUPING_ID is not part of the GROUP BY clause!
If CUBE and ROLLUP were indeed part of...
October 1, 2009 at 5:10 am
ChiragNS (9/23/2009)
oops!! thought the checkboxes where radio buttons.
And me. I even looked up the answer in BOL, as I'd never heard of the function, and so got the same only-partly-correct...
September 23, 2009 at 4:23 am
A pity that 11 wasn't one of the options - then we'd have had to decide whether casting 10.5 as an integer truncated or rounded (and I would probably have...
August 20, 2009 at 8:58 am
Cliff Jones (8/19/2009)
Mark Horninger (8/19/2009)
Actually, you could do an implicit or explicit conversion....I agree. That was my first thought as well.
Me too. Since there was no 'either implicit...
August 19, 2009 at 10:11 am
sknox (7/23/2009)
I haven't used SQL Server 6.5 or earlier, so I don't know if there was an alternate syntax or if you had to drop and recreate the column.
From memory,...
July 24, 2009 at 4:23 am
SanjayAttray (7/2/2009)
Very basic. But, still 16 people got it wrong as of now. Amazing. :hehe:
34 and counting...
July 3, 2009 at 5:29 am
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/1e04f7d6-3d82-45ab-9318-92e0640150b2.htm
June 23, 2009 at 3:29 am
hakan.winther (6/17/2009)
June 17, 2009 at 6:36 am
If you later find out it should be unicode, you can change it.
I assume you've never been through the process of converting a large database from varchar/char/text columns to nvarchar/nchar/ntext?...
June 16, 2009 at 2:47 am
Scott Coleman (6/8/2009)
I appreciate the need for NCHAR, but in over fifteen years of database programming and administration I have yet to need to support any foreign language characters.
The application...
June 8, 2009 at 10:08 am
Christian Buettner (6/8/2009)
Toreador (6/8/2009)
The best type cannot be one which will not work for a large subset of possible characters (ie any Unicode character)Why?
Because if the spec says you need...
June 8, 2009 at 6:03 am
The question asks for the 'best' type for storing a character. The best type cannot be one which will not work for a large subset of possible characters (ie any...
June 8, 2009 at 3:12 am
Richard Driscoll (5/28/2009)
oh come on! How does N-Var-Char translate to this answer!
Ask the people who created the ISO standards, as that's where it comes from!
May 29, 2009 at 6:25 am
One 'gotcha' is that if you rename a stored procedure, the code returned by sp_helptext will still have the original name 🙂
May 28, 2009 at 5:20 am
Viewing 15 posts - 631 through 645 (of 652 total)