Viewing 15 posts - 151 through 165 (of 317 total)
Good question. I need to stop answering questions before I get woke up.
August 8, 2013 at 7:33 am
Danny Ocean (8/6/2013)
Out of 3 i choose 2 correct and miss 1. today i learn something new.:-)
+ 1 :doze:
August 6, 2013 at 7:48 am
Thanks for the question Steve! Definitely learned something today.
July 25, 2013 at 7:49 am
Hugo Kornelis (7/24/2013)
Interesting question!Now I picked the right answer, but for the wrong reason (I thought the last CREATE INDEX would fail because of the duplicate index name).
Glad I'm not...
July 24, 2013 at 7:16 am
Danny Ocean (7/23/2013)
Hugo Kornelis (7/23/2013)
...
In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an...
July 23, 2013 at 7:41 am
Maybe this will help.
SELECT 1234 AS '@TranID', 'ABC123' AS '@OrderNum',
'MY' AS 'Current_Location',
(
SELECT 'OK' AS '@Code', 'FINE' AS '@Reason_Code', 'KUU1234' AS 'Remark'
FOR XML PATH('Status'), TYPE
) AS 'node()',
'A5555'...
July 22, 2013 at 7:41 am
Anipaul (7/18/2013)
Bangla (7/18/2013)
Revenant (7/18/2013)
As usual for Steve's questions, it had me scrambling for MSDN. Thanks, Steve!Yes I agree ...
+1
+1
July 19, 2013 at 8:21 am
+1 this did the trick for me too!
July 15, 2013 at 9:53 am
logitestus (7/12/2013)
Foiled again!Great question, I have definitely spent 30 minutes delving into something I have never touched on in SQL Server.
+1 Agreed. I have learned something new today. Thanks Steve!
July 12, 2013 at 7:19 am
Viewing 15 posts - 151 through 165 (of 317 total)