drop

Question

drop

VM-723206

SSCrazy

Points: 2964
More actions
December 27, 2009 at 6:30 am

#218983

Comments posted to this topic are about the item drop

Viewing 14 posts - 1 through 13 (of 13 total)

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

Jan Van der Eecken SSCrazy Eights Points: 9029 More actions · Answer 1

Uhm, I got it right, but certainly the "correct" answer is wrong because not just the two columns are dropped but the whole table is?

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

akmi Say Hey Kid Points: 693 More actions · Answer 2

akmi

Say Hey Kid

Points: 693

December 28, 2009 at 5:18 am

#1096641

Agreed....

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 3

I also agree. The whole table will be dropped.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Steve Jones - SSC Editor SSC Guru Points: 736078 More actions · Answer 4

I've removed the drop table from the question. It was to do the cleanup in testing, but I agree that it confuses the issue.

shanmugavel_1984 Valued Member Points: 65 More actions · Answer 5

shanmugavel_1984

Valued Member

Points: 65

December 28, 2009 at 10:23 pm

#1096897

please dont post this type of sappai questions.

Bhavesh_Patel SSCrazy Points: 2259 More actions · Answer 6

This was easy one

[font="System"]Bhavesh Patel[/font]

http://bhaveshgpatel.wordpress.com/

sihaab SSCommitted Points: 1742 More actions · Answer 7

Anyone can answer these kind of questions right by just cut and past to their SSMS

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

sihaab (1/4/2010)
Anyone can answer these kind of questions right by just cut and past to their SSMS

That may be true, however they are at least given the opportunity to answer them before doing that. It also still offers a chance to learn even if a cut and paste was performed into SSMS.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sihaab SSCommitted Points: 1742 More actions · Answer 9

sihaab

SSCommitted

Points: 1742

January 4, 2010 at 1:10 pm

#1098604

That make sense.

BudaCli Hall of Fame Points: 3404 More actions · Answer 10

Already knew about this and tx

What you don't know won't hurt you but what you know will make you plan to know better

suryam Mr or Mrs. 500 Points: 569 More actions · Answer 11

dear

How d whole table will drop ....could u plz elaborate

Thanks
SUrya

Hafiz-1142834 SSC Veteran Points: 260 More actions · Answer 12

Hafiz-1142834

SSC Veteran

Points: 260

January 11, 2010 at 12:58 am

#1101635

It puts thought when we answer such questions.

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 13

Doesn't this work all the way back to SQL 7??

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems