To Update Should I Delete before Insert

Published by: Jivan (8/18/2008)

I want to update a table but the records are huge so here is case i have to delete all and insert. I guess if i delete all and lose the connection before insert then i might run into issues. What you suggest me to do? Should i just insert first and record the ids to delete in the next query?

 

Most Popular Articles

• How can I run my Stored Procedure in SQL Server 2005
• SQL Join Query for Microsoft Access Database
• What is the use of nolock condition in SQL Query
• How can I Truncate my Database Log to Reduce the Size
• when to use cast and when to use convert operator in SQL

How can I run my Stored Procedure in SQL Server 2005 >>

<< How can I insert a Record to Database and get the ID in Same Query