Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am huntaub on github.
  • I am hunter_leath (https://keybase.io/hunter_leath) on keybase.
  • I have a public key whose fingerprint is 2F1A EE48 1F82 4EB9 71DF 2013 D27A 0FD4 E360 46F6

To claim this, I am signing this object:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
BEGIN TRANSACTION;
Declare @counter int
select @counter = counterID from myTable order by counterID asc
select @counter = @counter + 1
INSERT INTO myTable (counterID) VALUES (@counter)
Select @counter as newCounterID
COMMIT TRANSACTION;