Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding Duplicate Records
Message
 
 
To
07/08/2008 19:47:25
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01337412
Message ID:
01337420
Views:
16
http://wiki.answers.com/Q/How_do_you_differentiate_between_truncate_and_delete

>Naomi:
>
>I'd rather not go through all the records 1-by-1 just to delete records.
>
>At this time I'm only concerned with 1 table. This table has about 50,000 records. Would it be wise to just delete all the records in this table and just IMPORT all the updated records from the updated table? How would one delete all the records in a table?
>
>Mal
>
>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform