SQL POP Quiz
-
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)
-
NON!!! it will actually not even compile, the sub select does not contain the item table from which the field DID is selected!!!
-
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
-
Rdijk,
You might want to read (or re-read) the earlier posts.
Andy
-
Very cool problem Tom!! Never come across something like this in the past but I will be looking out for it now. Thanks!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply