- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
CREATE PROCEDURE [dbo].[getNextBatchId]
AS
BEGIN
DECLARE @NewSeqValue int
SET NOCOUNT ON
INSERT INTO dbo.BatchId_SSQ_SequenceGenerator ([NextBatchId]) VALUES ('a')
SET @NewSeqValue = scope_identity()
DELETE FROM dbo.BatchId_SSQ_SequenceGenerator WITH (READPAST)
SELECT @NewSeqValue as NextBatchId
END;
GO
Комментарии (0) RSS
Добавить комментарий