Skip to content

Instantly share code, notes, and snippets.

View jhleath's full-sized avatar

Hunter Leath jhleath

37 followers · 21 following
View GitHub Profile
@jhleath
jhleath / keybase.md
Created April 7, 2015 21:50

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:

@jhleath
jhleath / MS SQL Atomic Increment.sql
Created June 17, 2010 14:41
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;