TRUNCATE TABLE @table_name

#1

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

#2

Boogha (boogha (AT) gmail (DOT) com) writes:

Quote:

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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

On Nov 26, 7:07 am, Boogha <boo... (AT) gmail (DOT) com> wrote:

Quote:

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/madhiv...s-part-ii.aspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

TRUNCATE TABLE @table_name

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

TRUNCATE TABLE @table_name - 11-25-2007 , 08:07 PM

Re: TRUNCATE TABLE @table_name - 11-26-2007 , 02:26 AM

Re: TRUNCATE TABLE @table_name - 11-26-2007 , 08:12 AM