February 25, 2014 at 8:11 am
easy one as long as you as you don't just glance at the answers an then PICK THE WRONG ONE.
February 25, 2014 at 9:57 am
easy question..
Thanks.
February 26, 2014 at 12:41 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 2:37 am
I haven't made this mistake yet (that I know of) but I am not certain that I knew this. In fact, I don't think I did. This question was excellent as it made me test something that is fundamental AND a fundamental omission in my knowledge. Or at least it was 😉
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
February 26, 2014 at 10:49 am
How odd. I actually tried running this (copy/pasted the code) and got the following:
(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero error encountered.
No 'A' at all....
February 26, 2014 at 11:03 am
robert.diley (2/26/2014)
How odd. I actually tried running this (copy/pasted the code) and got the following:(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero error encountered.
No 'A' at all....
Hmm... which version of SQLS are you running?
February 26, 2014 at 11:03 am
Easy... Thanks, Milos!
February 26, 2014 at 11:08 am
2008 R2
February 26, 2014 at 11:37 am
I will try to recreate the problem.
February 26, 2014 at 2:17 pm
robert.diley (2/26/2014)
How odd. I actually tried running this (copy/pasted the code) and got the following:(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero error encountered.
No 'A' at all....
It may be that you're only looking at the "Messages" Pane. Take a look at both the "Results" and "Messages" panes.
February 26, 2014 at 2:35 pm
dj341 (2/26/2014)
robert.diley (2/26/2014)
How odd. I actually tried running this (copy/pasted the code) and got the following:(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero error encountered.
No 'A' at all....
It may be that you're only looking at the "Messages" Pane. Take a look at both the "Results" and "Messages" panes.
You can see all resulted lines when you set Results to Text in the SQL Server Management Studio to force query execution results to be displayed as text.
___________________________
Do Not Optimize for Exceptions!
February 26, 2014 at 9:19 pm
Revenant (2/26/2014)
robert.diley (2/26/2014)
How odd. I actually tried running this (copy/pasted the code) and got the following:(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero error encountered.
No 'A' at all....
Hmm... which version of SQLS are you running?
On a second thought... Have you clicked on the Results tab?
February 26, 2014 at 9:21 pm
milos.radivojevic (2/26/2014)
dj341 (2/26/2014)
robert.diley (2/26/2014)
How odd. I actually tried running this (copy/pasted the code) and got the following:(1 row(s) affected)
Msg 8134, Level 16, State 1, Procedure TestProc, Line 6
Divide by zero error encountered.
No 'A' at all....
It may be that you're only looking at the "Messages" Pane. Take a look at both the "Results" and "Messages" panes.
You can see all resulted lines when you set Results to Text in the SQL Server Management Studio to force query execution results to be displayed as text.
Sorry, Milos, I missed your reply - seemed too obvious...
Once again, thanks for the question.
February 27, 2014 at 12:22 pm
Simple one. Thanks for sharing!
March 3, 2014 at 2:26 am
Too easy, amazing 38% wrong answers 😎
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply