Posted by Madhivanan on 11/26/07 14:12

On Nov 26, 7:07 am, Boogha <boo...@gmail.com> 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

• Next in forum: many "or" operation make system choose incorrect index
• Prev in forum: Re: Create table and default order by clause
• Thread view: Re: TRUNCATE TABLE @table_name

[Reply to this message]