SQL2008中的Sequence

CREATETABLEdbo.GlobalSequence

(

idINTIDENTITY(1, 1)

)

GO

CREATEPROCseq(@id INTOUTPUT)

AS

BEGIN

BEGINTRAN

DECLARE@NewSequenceValueTABLE (ID INT);

INSERTINTOdbo.GlobalSequence

OUTPUTinserted.id

INTO@NewSequenceValue

DEFAULTVALUES

ROLLBACKTRAN

SELECT@id=id

FROM@NewSequenceValue

END

-- test

DECLARE@idINT

EXECseq@id OUTPUT

SELECT@id