Viewing 15 posts - 841 through 855 (of 8,415 total)
Koen Verbeeck (2/2/2012)
SQL Kiwi (2/2/2012)
An article about clearly documented behaviour, and no mention of the more serious problems with COALESCE? Poor.
Now you make me curious. Which issues are you...
February 2, 2012 at 1:02 am
Koen Verbeeck (2/1/2012)
Great question. I was looking for a trap, but apparently there wasn't any 😀
Me too. I was expecting:
GO
CREATE TABLE dbo.Test
(
ID ...
February 2, 2012 at 12:27 am
An article about clearly documented behaviour, and no mention of the more serious problems with COALESCE? Poor.
February 2, 2012 at 12:07 am
danielfountain (2/1/2012)
I am not 100% sure what the numbers table is exactly doing - but i will look at it in more detail shortly.
Thanks. If you mean the weird-looking...
February 1, 2012 at 5:52 am
danielfountain (2/1/2012)
However the question was still wrong as you still dont reference another column. You reference a UDF.
Meh, semantics.
February 1, 2012 at 1:15 am
honza.mf (2/1/2012)
I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.
:laugh: I like it!
February 1, 2012 at 1:14 am
You may find this form makes better use of any indexes you might have:
IF @Option = 1
BEGIN
SELECT *
FROM dbo.Inventory AS...
January 31, 2012 at 11:51 pm
A confused question with no right answer. All of the above indeed :rolleyes:
January 31, 2012 at 11:11 pm
Steve Jones - SSC Editor (1/31/2012)
SQL Kiwi (1/31/2012)
Ok, the embedded quotes occupy a whole screen now...I need a filter to whack multiple embedded quotes. It can be quite annoying.
Great idea!
This...
January 31, 2012 at 12:44 pm
Ok, the embedded quotes occupy a whole screen now...
January 31, 2012 at 12:29 pm
jcb (1/31/2012)
Just go direct to the point: Deactivating this messagens ill deactivate also usefull messages and you cannot guarantee correctness...
January 31, 2012 at 12:14 pm
SQLKnowItAll (1/31/2012)
January 31, 2012 at 12:14 pm
b5535084 (1/31/2012)
TOP: CPU time = 1281 ms, elapsed time = 7777 ms, logical reads 223933 (ORDER_ITEM_DIM)
ROW_NUMBER: CPU time = 2000 ms, elapsed time = 15948 ms, logical reads 303216 (ORDER_ITEM_DIM)
TOP...
January 31, 2012 at 11:47 am
SQLKnowItAll (1/31/2012)
January 31, 2012 at 11:37 am
GilaMonster (1/31/2012)
SQL Kiwi (1/31/2012)
GilaMonster (1/31/2012)
jcb (1/31/2012)
Can You rely on a trigger to safe truncate the data to the column?No, because types are checked before triggers fire.
Yes, if you use a...
January 31, 2012 at 11:35 am
Viewing 15 posts - 841 through 855 (of 8,415 total)