Posted by Erland Sommarskog on 11/26/07 08:26

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: relation schema SQL Server 2005
• Prev in forum: Re: Concat instead of SUM when grouping results
• Thread view: Re: TRUNCATE TABLE @table_name

[Reply to this message]