Hi,
I have to delete some amnt of data and insert some into same table.
Will there be any performance improvement if we go for Upsert in a loop ?
Thanks in advance!
+4
A:
No. Just use a simple
DELETE ...
INSERT ...
...probably in a transaction too
You can't "UPSERT" in SQL Server 2005. MERGE was added for SQL Server 2008.
A loop is almost never the answer for any query in a database engine
gbn
2010-10-15 19:30:51
I am working inn sql server 2008 (I didnt select it bcoz 2008 is not available in the list).
Anish
2010-10-15 19:45:55
So, Is merge faster ?
Anish
2010-10-15 19:56:31
@Anish: I have no tested but it's probably the same because still has to do the same combined insert/update/delete
gbn
2010-10-17 14:11:39