SQL CMD

Question

Post reply

SQL CMD

Steve Jones - SSC Editor

SSC Guru

Points: 735611
More actions
February 7, 2011 at 11:25 pm

#63713

Comments posted to this topic are about the item SQL CMD

Viewing 15 posts - 1 through 15 (of 31 total)

You must be logged in to reply to this topic. Login to reply

M&M SSC-Insane Points: 21700 More actions · Answer 1

M&M

SSC-Insane

Points: 21700

February 7, 2011 at 11:49 pm

#1283543

Very good question.Thanks.

M&M

Koen Verbeeck SSC Guru Points: 259095 More actions · Answer 2

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

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 3

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

Cedz Mr or Mrs. 500 Points: 502 More actions · Answer 4

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

chirag.makwana Newbie Points: 3 More actions · Answer 5

Good Question..

The Above Question Answer is..

http://msdn.microsoft.com/en-us/library/ms174187(v=SQL.100).aspx

Thanks...

Chirag Makwana.

Koen Verbeeck SSC Guru Points: 259095 More actions · Answer 6

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

RichB SSCrazy Eights Points: 9651 More actions · Answer 7

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?

paul s-306273 SSChampion Points: 10730 More actions · Answer 8

paul s-306273

SSChampion

Points: 10730

February 8, 2011 at 6:14 am

#1283631

Easy question today.

OCTom SSChampion Points: 11785 More actions · Answer 9

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 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?

It depends on which question you consider the actual question. The answer is yes to the first question and no to the second.

OCTom SSChampion Points: 11785 More actions · Answer 10

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.

rVadim Hall of Fame Points: 3969 More actions · Answer 11

I also thought that !DIR is just a typo and answered correctly.

But why 2008? It works fine in 2005 as well.

--Vadim R.

Thomas LeBlanc SSCrazy Eights Points: 8075 More actions · Answer 12

!Dir does not work, it has to be !!Dir

Thomas LeBlanc, MVP Data Platform Consultant

Abi Chapagai SSCrazy Points: 2666 More actions · Answer 13

I agree with Thomas, !DIR does not work, it has to be !!DIR. I am sure it is Typo.

Steve Jones - SSC Editor SSC Guru Points: 735611 More actions · Answer 14

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.