SQL POP Quiz

Question

SQL POP Quiz

Viewing 5 posts - 16 through 20 (of 20 total)

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

Antares686 SSC Guru Points: 125444 More actions · Answer 1

When I test UPDATES, INSERTS and DELETES I do a SELECT, BEGIN TRANS, SELECT, and ROLLBACK TRANS to be sure in testing the results were as expected even if I have tested the Select version.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

R. C. van Dijk SSChasing Mays Points: 603 More actions · Answer 2

NON!!! it will actually not even compile, the sub select does not contain the item table from which the field DID is selected!!!

Kashif SSCommitted Points: 1881 More actions · Answer 3

The same type of delete statement caused one of tables in our database empty i.e. deleted all rows.

I got (8 row(s) affected).

Edited by - kashif on 07/16/2002 02:08:16 AM

Andy Warren SSC Guru Points: 119902 More actions · Answer 4

Rdijk,

You might want to read (or re-read) the earlier posts.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
Connect with me on LinkedIn

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 5

Very cool problem Tom!! Never come across something like this in the past but I will be looking out for it now. Thanks!

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot