TRUNCATE TABLE @table_name

I have a cursor looping through a list of tables that I want to
truncate and then do a bulk insert into, Is this possible in SQL
Server 2000 or do script each table individually.

Cheers,
Adam

Re: TRUNCATE TABLE @table_name

Boogha (boogha@gmail.com) writes:
> I have a cursor looping through a list of tables that I want to
> truncate and then do a bulk insert into, Is this possible in SQL
> Server 2000 or do script each table individually.

Seems like you need to learn dynamic SQL:

EXEC('TRUNCATE TABLE ' + @table)

And while that looks very simple, before you use it all over town, there is
an article on my web site that tries to explain both the benefits and the
pitfalls: http://www.sommarskog.se/dynamic_sql.html.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: TRUNCATE TABLE @table_name

On Nov 26, 7:07 am, Boogha wrote:
> I have a cursor looping through a list of tables that I want to
> truncate and then do a bulk insert into, Is this possible in SQL
> Server 2000 or do script each table individually.
>
> Cheers,
> Adam

If you want to truncate all the tables, then try this
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/ truncate-all-tables-part-ii.aspx