>Here's a little brain teaser. This could be a "who's buried in Grant's tomb" question....or it might be a trick question.
>
>Here we go. In SQL Server, suppose you're in a SQL transaction. During the transaction, you truncate a table by issuing the TRUNCATE TABLE statement. Let's say the table had 100 rows before the TRUNCATE.
>
>Here's the question - can you issue a ROLLBACK statement and bring back the 100 rows?
>
>
>Obviously, you could cheat and try it out in SQL Server, so I'm asking for honesty.
>
>There's a story behind this question.....
I have no experience to back this up but since TRUNCATE TABLE does no logging, I'd intuit that there's no ROLLBACK possible and would use DELETE instead if I wanted ROLLBACK.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.