Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE s_AccountDetails_Upsert ( @Email nvarchar(4000), @Etc nvarchar(max) )
- AS
- SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
- BEGIN TRAN
- IF EXISTS ( SELECT * FROM dbo.AccountDetails WITH (UPDLOCK) WHERE Email = @Email )
- UPDATE dbo.AccountDetails
- SET Etc = @Etc
- WHERE Email = @Email;
- ELSE
- INSERT dbo.AccountDetails ( Email, Etc )
- VALUES ( @Email, @Etc );
- COMMIT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement