tag:blogger.com,1999:blog-495177919198719500.post7019237659147973531..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: If Row Exists Update, Else Insert in SQL ServerSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-495177919198719500.post-21839715774240152932012-10-29T03:31:03.147-07:002012-10-29T03:31:03.147-07:00This is not thread safeThis is not thread safeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-61782243775847948082012-03-30T17:58:59.200-07:002012-03-30T17:58:59.200-07:00other faster technique is using MERGE Statementother faster technique is using MERGE StatementAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-32311745213696837032011-01-13T11:34:56.556-08:002011-01-13T11:34:56.556-08:00A good !.Thanks!!!A good !.Thanks!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-61065430719791819382010-03-15T08:08:01.137-07:002010-03-15T08:08:01.137-07:00Other technique is
UPDATE.....
IF @@ROWCOUNT=0...Other technique is <br /><br /><br />UPDATE.....<br /><br />IF @@ROWCOUNT=0<br /><br />INSERT.......Madhivananhttp://beyondrelational.com/blogs/madhivanannoreply@blogger.com