Advertisement
deSantoz

Upsert in SQL Server

May 8th, 2019
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.44 KB | None | 0 0
  1. CREATE PROCEDURE s_AccountDetails_Upsert ( @Email nvarchar(4000), @Etc nvarchar(max) )
  2. AS
  3.   SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
  4.   BEGIN TRAN
  5.  
  6.     IF EXISTS ( SELECT * FROM dbo.AccountDetails WITH (UPDLOCK) WHERE Email = @Email )
  7.  
  8.       UPDATE dbo.AccountDetails
  9.          SET Etc = @Etc
  10.        WHERE Email = @Email;
  11.  
  12.     ELSE
  13.  
  14.       INSERT dbo.AccountDetails ( Email, Etc )
  15.       VALUES ( @Email, @Etc );
  16.  
  17.   COMMIT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement