emptying an MSSQL table

[Peter Bateman]

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 Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.