January 2008 - Posts

0
Comments

Truncating all tables by bunbun

This is a nifty little stored procedure that loops through all the tables in a database and allows you to pass a command to execute. In my case, I wanted to truncate all the tables prior to loading new data so I just used: EXEC sp_MSForEachTable 'Truncate...
Filed under:
More Posts