Rollback

[Michael Groves]

Would it be bad practice/poor on CPU to routinely use a rollback when there isnt actually an error? So insert data into the database, use the data to process information, then rollback the changes.

[NeoPa]

I would say so.

It would make more sense to design a table specifically for your usage, then delete the records afterwards when they are no longer required. The table remains for future use, but not the records.

[ck9663]

Or just setup a dev environment for that sort of thing...


~~ CK

[Rabbit]

Or use a table variable. It all depends on what you're actually trying to do.