RSS feed

To Update Should I Delete before Insert

Published by: Jivan (8/18/2008)

AUG 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?


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



You can use HTML tags here.
*Code: Please enter the sum of 5+2