Viewing 15 posts - 46 through 60 (of 90 total)
UMG Developer (6/13/2010)
I got it wrong because I didn't read the question correctly, I thought it was asking how many rows where returned.
Somwhere within my neuron subsystem, I noticed the...
June 14, 2010 at 8:15 am
CirquedeSQLeil (6/9/2010)
Thanks. True - BOL does state that the MODEL DB cannot be set to ReadOnly, that's why I found this to be an interesting behavior.
Agreed. Good QotD,...
June 10, 2010 at 8:30 am
honza.mf (5/25/2010)
If someone uses case sensitive collation, he will have all characters in uppercase.
Sounds reasonable, but use COLLATE Czech_CS_AS (instead of the case-insensitive collation) -- SELECT DISTINCT will return three...
May 25, 2010 at 2:43 pm
honza.mf (5/25/2010)
If someone uses case sensitive collation, he will have all characters in uppercase.
Sorry, ignore this reply and see my next reply :-). Thanks.
May 25, 2010 at 2:40 pm
malleswarareddy_m (5/25/2010)
...select string from #t where string COLLATE CZECH_CI_AS like '_'
the above you have given returns gives
CH
Ch
ch
¢h
four rows.
...
I was wondering why my SQL Query Analyzer output apparently listed "ch"...
May 25, 2010 at 8:24 am
Niths (5/24/2010)
I executed this query in SQL Client 2008 but i did not receive any output. Instead it just said "Commands executed successfully"...!:(
The QotD was "What result will @hourdiff hold?"...
May 24, 2010 at 8:33 am
Paul White NZ (5/7/2010)
Michael Poppers (5/7/2010)
Paul, isn't it worth noting the different "ThePrecision" results from the sql_variant_property() output noted earlier in this discussion? Would you like me to add...
May 10, 2010 at 11:09 am
Christian Buettner-167247 (5/7/2010)
Paul White NZ (5/6/2010)
Please vote and mark as reproducible if you can.Done 🙂
Ditto.
Paul, isn't it worth noting the different "ThePrecision" results from the sql_variant_property() output noted earlier in...
May 7, 2010 at 10:15 am
webrunner (5/4/2010)
If it turns out that the error is only in some clients,...
May 4, 2010 at 8:12 am
Hugo responded:
In this case, the code runs (the comma is actually not permitted by a strict interpretation of Books Online, but the parser happens to be forgiving in this case).
True,...
April 20, 2010 at 2:01 pm
Hi, Hugo! and thanks for your QotD (which, despite my best efforts, I got right :-)). Just wanted to note (and I'm shocked, SHOCKED, that with 27 posts thus...
April 20, 2010 at 8:36 am
Hugo Kornelis (1/21/2010)
January 21, 2010 at 9:58 am
robert_edis (1/6/2010)
If the UPDATE statement has a WHERE clause of CategoryID = 7 but no records have been previously loaded then it cannot write any data...
January 7, 2010 at 8:14 am
john.curran.z3g (1/6/2010)
January 6, 2010 at 8:31 am
Viewing 15 posts - 46 through 60 (of 90 total)