CATEGORIES
Acer
AMD
Apache
Apple
ASP
Business Object
Compaq
Crystal Reports
CSS
Database
Dell
DOT NET
Fujitsu
Gateway
Google
HP
HTML
IBM
IIS
Intel
Java
Mainframe
Microsoft
Networking
Oracle
SAP
SEO
Sony
SQL Server
Testing
Tomcat
Toshiba
Ubuntu
Visual Basic
Web Hosting
Windows
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
- SQL Join Query for Microsoft Access Database
- SQL Query to Copy and Insert a Record from Same Table
- What is the use of nolock condition in SQL Query
- How can I run my Stored Procedure in SQL Server 2005
- How do I Design a Database Which can Easily Handle the 10 Levels of Categories
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
COMMENT