Truncate/Clear table variable in SQL Server 2008
sql, sql-server, t-sql
Solution
just delete everything
DELETE FROM @tableVariable
Problem
Is it possible to truncate or flush out a table variable in SQL Server 2008? ``` declare @tableVariable table ( id int, value varchar(20) ) while @start <= @stop begin insert into @tableVariable(id, value) select id , value from xTable where id = @start --Use @tableVariable --@tableVariable should be flushed out of -- old values before inserting new values set @start = @start + 1 end ```