SQL Server 2008 r2?

Question

Post reply

SQL Server 2008 r2?

Shiva N

Hall of Fame

Points: 3125
More actions
August 26, 2014 at 11:07 pm

#292623

Comments posted to this topic are about the item SQL Server 2008 r2?
Thanks,
Shiva N
Database Consultant
August 27, 2014 at 3:08 am

This was removed by the editor as SPAM

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

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

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 1

Got too hurried up... did not even see "choose 2" :w00t:

Umer Akram SSC-Insane Points: 22209 More actions · Answer 2

Shiva, It is me or it is just repeated question shared on "Choose only two correct answers? " on 21 Aug 2014

with different correct answers 😛

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

twin.devil (8/26/2014)
Shiva, It is me or it is just repeated question shared on "Choose only two correct answers? " on 21 Aug 2014
with different correct answers 😛

Yes, 😀

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

I see 4 correct answers.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 5

Sean Pearce (8/27/2014)
I see 4 correct answers.

Indeed.

Quite the déjà vu, this question...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

robertjtjones SSC-Addicted Points: 484 More actions · Answer 6

There are definitely more than 2 correct answers here Shiva.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Thank you for the post, Shiva, interesting one.

(at first I did not pay attention on the variable size, so I selected two options which seemed right, then I re-read the question and that "30" changed my thinking... and again I ended selecting other two, but forgot to uncheck the previous two. In 4 selections, two were correct answers.

Like others said, this has more than two correct choices (or at least it feels to me), but still, overall the question is good, simple, the size of the variable changes entire perspective of the post.:-)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Paul Keys SSC Eights! Points: 866 More actions · Answer 8

Koen Verbeeck (8/27/2014)
Sean Pearce (8/27/2014)
I see 4 correct answers.
Indeed.
Quite the déjà vu, this question...

+1

Carlo Romagnano SSC-Insane Points: 22600 More actions · Answer 9

What do you mean with "we can use print and exec commands in single query"?

Mighty SSCrazy Eights Points: 9063 More actions · Answer 10

Not sure I see 4 correct answers (taking the "only" part of the first answer strict, so that any size other than 116 would not work), but 3 correct answers at least.

The option the print and execute command can be used in one query is correct according to me. First it is unclear what is meant by "one query". But besides that, the following code works, so it proves this option should be seen as correct.

EXEC('PRINT ''also works''')

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 11

Carlo Romagnano (8/27/2014)
What do you mean with "we can use print and exec commands in single query"?

that word "query" is confusing... I guess he means in one "batch" or in one session (like we execute the some set of specific lines and then execute)..

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

DirkVerriet Grasshopper Points: 16 More actions · Answer 12

Clearly there are more then 2 answers. Please fix it.

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 13

I can see more right answers.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature