Thursday, October 21, 2010

Dynamically Pass a Table Name to TRUNCATE TABLE

GO
DECLARE @tbl varchar(30) = 'YourTableName'
DECLARE @dynSQL varchar(50)
SET @dynSQL = 'TRUNCATE TABLE ' + @tbl
EXEC (@dynSQL)

No comments:

Post a Comment