emptying an MSSQL table

[Guy Werry]

Actually, Joe, the TRUNCATE TABLE is far better than dropping the table.  First off, it's much faster; secondly you don't have to re-create the table like you would if you drop the table.  Much cleaner and (in our Oracle world) faster.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
Joe Boyle
Sent: Tuesday, April 11, 2006 1:50 PM
To: powerh-l at lists.sowder.com
Subject: RE: emptying an MSSQL table


or even 'drop table table_name;'

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Peter Bateman
Sent: 11 April 2006 18:58
To: powerh-l at lists.sowder.com
Subject: RE: emptying an MSSQL table


Viet:

  MS SQL Server also has TRUNCATE TABLE.

  I don't know if you can call it from a stored procedure or not!

Regards,
Peter Bateman


>Viet,
>
>I know from my experience with SQL and Oracle that deletes are slow because

>the indexes are being re-built as the deletions happen.
>
>In SQL/Oracle there is a TRUNCATE TABLE command that empties a table very 
>efficiently ... unfortunately, I don't know is MSSQL has an equivalent.
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>-----Original Message-----
>From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
>[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
>Viet Nguyen
>Sent: Tuesday, April 11, 2006 11:00 AM
>To: powerh-l at lists.sowder.com
>Subject: emptying an MSSQL table
>
>
>Could someone tell me which command I can use to empty out an MSSQL
>table using Powerhouse QTP? I am using delete from table but it seems
>slow on large files.
>Thanks.
>
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented MicrosoftR 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt
p://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSNR Premium right now and get the 
first two months FREE*.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.