Truncate variable table

Question

Truncate variable table

Viewing 3 posts - 1 through 4 (of 4 total)

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

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

you can't truncate a table variable. you could either use a temp table or just simply create a new table variable and use it and just let them both fall out of scope at the end.

Sergiy SSC Guru Points: 110209 More actions · Answer 2

It's always good to read whole related topics in BOL and try to understand WHY.

Truncating a table is faster than deleting the records in a table because it does uses simplest table lock and it does record transactions into log.

None of these is used for table variables.

So, DELETE from table variable is as good as TRUNCATE would be.

_____________
Code for TallyGenerator

khaledhusseinie Grasshopper Points: 11 More actions · Answer 3

I know its to late 🙂 but to help others I commented

you can truncate using the command mentioned below

DELETE FROM @myList

This reply was modified 4 years, 10 months ago by khaledhusseinie.