存储过程代码

--生产ID

DECLARE @i INT
SET @i=1
WHILE @i<30
BEGIN
	SELECT @NewId=CAST([NewId] AS VARCHAR(10)) FROM CRM_NewId WHERE Name='Coupon'
	UPDATE CRM_NewId SET [NewId]=[NewId]+1 WHERE Name='Coupon' AND [NewId]=@NewId
	IF @@ROWCOUNT>0
	BEGIN
		SET @i=100
		SET @NewId = @NewId+1
	END
	ELSE
	BEGIN
		SET @i=@i+1
		SET @NewId = NULL
	END
END


IF @NewId IS NULL
BEGIN
	PRINT '更新优惠券ID出错，开始回滚'   
	ROLLBACK TRANSACTION  
	RETURN 
END