SQL2008中的Sequence

?

?

CREATE TABLE dbo.GlobalSequence

(

id INT IDENTITY(1, 1)

)

GO

?

?

CREATE PROC seq ( @id INT OUTPUT )

AS

BEGIN

BEGIN TRAN

DECLARE @NewSequenceValue TABLE ( ID INT );

?

INSERT INTO dbo.GlobalSequence

OUTPUT inserted.id

INTO @NewSequenceValue

DEFAULT VALUES

?

ROLLBACK TRAN

SELECT @id = id

FROM @NewSequenceValue

?

?

END

?

-- test

DECLARE @id INT

EXEC seq @id OUTPUT

SELECT @id

SQL2008中的Sequence

原文：http://www.cnblogs.com/QinQouShui/p/4320569.html