Trucate Command

From: Garry Dawkins (anonymous_at_discussions.microsoft.com)
Date: 05/06/04

  • Next message: Vishal Parkar: "RE: Trucate Command" 
    Date: Thu, 6 May 2004 12:04:58 -0700

    Hello, I have a table with 200,000,000 records and need
    only 20,000 or 6 months of historical data. Ive created a
    temp_tbl and I'm inserting the 6 months worth of data that
    I need. Can I use the truncate command???. Can I use it
    to bring the temp_table data back to the original table
    with out reprocusions?
    .

  • Next message: Vishal Parkar: "RE: Trucate Command"

    Relevant Pages

    • Truncate Command
      ... only 20,000 or 6 months of historical data. ... temp_tbl and I'm inserting the 6 months worth of data that ... Can I use the truncate command???. ... with out reprocusions? ...
      (microsoft.public.sqlserver.datamining)
    • Re: ASP ORACLE VB
      ... TRUNCATE removes all of the rows in the table and is similar to DELETE FROM except it is not reversible. ... > "Al Reid" wrote in message ... >> previously stated, truncate the table and start inserting records, being ... >> insert into an Oracle database fail with a violation of a Unique ...
      (microsoft.public.vb.database)
    • Insert with Index VS Insert without Index
      ... As a process we truncate the table and insert ... B.)Also we tried inserting 1M records without indexes and ... do the inserts with indexes with in a resonable time. ... Regards, ...
      (microsoft.public.sqlserver.server)