February 7, 2011 at 11:49 pm
Very good question.Thanks.
M&M
February 8, 2011 at 1:11 am
Nice question, learned something today. Thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2011 at 2:18 am
Another QOD, another new thing learned - thanks!
And a nice reminder that I really must sit down one day and find out what all the other buttons and menu options on SSMS actually do.
Duncan
February 8, 2011 at 2:49 am
I am sorry but the question is flawed , the correct command is in fact "!!DIR" with a double exclamation mark and not a single one "!DIR" like the QoD states, as a result I answered NO .Please review questions before posting
February 8, 2011 at 2:58 am
Good Question..
The Above Question Answer is..
http://msdn.microsoft.com/en-us/library/ms174187(v=SQL.100).aspx
Thanks...
Chirag Makwana.
February 8, 2011 at 3:11 am
Cedric-295411 (2/8/2011)
I am sorry but the question is flawed , the correct command is in fact "!!DIR" with a double exclamation mark and not a single one "!DIR" like the QoD states, as a result I answered NO .Please review questions before posting
The actual question "Can you execute SQLCMD statements using SSMS SQL Server 2008?" can be answered without looking at the example.
Would you have anwered the question correctly without the example?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 8, 2011 at 4:14 am
That rather depends on whether he thought it was one of the typically arsey trick questions...
Perhaps a rule of thumb is to only use 1 question mark per question?
February 8, 2011 at 6:14 am
Easy question today.
February 8, 2011 at 7:15 am
Koen (da-zero) (2/8/2011)
Cedric-295411 (2/8/2011)
I am sorry but the question is flawed , the correct command is in fact "!!DIR" with a double exclamation mark and not a single one "!DIR" like the QoD states, as a result I answered NO .Please review questions before postingThe actual question "Can you execute SQLCMD statements using SSMS SQL Server 2008?" can be answered without looking at the example.
Would you have anwered the question correctly without the example?
It depends on which question you consider the actual question. The answer is yes to the first question and no to the second.
February 8, 2011 at 7:17 am
RichB (2/8/2011)
That rather depends on whether he thought it was one of the typically arsey trick questions...Perhaps a rule of thumb is to only use 1 question mark per question?
I doubt that Steve was intentionally trying to trick anyone. I looked at the second question and viewwed that as a typing error.
February 8, 2011 at 8:34 am
I also thought that !DIR is just a typo and answered correctly.
But why 2008? It works fine in 2005 as well.
--Vadim R.
February 8, 2011 at 9:12 am
!Dir does not work, it has to be !!Dir
Thomas LeBlanc, MVP Data Platform Consultant
February 8, 2011 at 10:56 am
I agree with Thomas, !DIR does not work, it has to be !!DIR. I am sure it is Typo.
February 8, 2011 at 11:22 am
Cedric-295411 (2/8/2011)
I am sorry but the question is flawed , the correct command is in fact "!!DIR" with a double exclamation mark and not a single one "!DIR" like the QoD states, as a result I answered NO .Please review questions before posting
Apologies for the typo, which has been corrected, but it says "things like "!DIR", not that command specifically. It asks about specific SQLCMD functions, and do answer "no" saying that this isn't a valid command appears to be completely misreading the question.
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply