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