CREATE Procedure get_free_id
/* Param List */
(
@id INT OUTPUT,
@rt INT OUTPUT
)
AS
DECLARE @temp INT
DECLARE @count INT
SET @rt = 0
SET @count = 1
SELECT TOP 1 @temp=Id FROM tb_free_id WHERE lock = 0
IF @temp IS NOT NULL
BEGIN
UPDATE tb_free_id SET lock = 1 WHERE id = @temp
SET @id = @temp
SET @rt = 1
END
ELSE
SET @rt = -1GO
/* Param List */
(
@id INT OUTPUT,
@rt INT OUTPUT
)
AS
DECLARE @temp INT
DECLARE @count INT
SET @rt = 0
SET @count = 1
SELECT TOP 1 @temp=Id FROM tb_free_id WHERE lock = 0
IF @temp IS NOT NULL
BEGIN
UPDATE tb_free_id SET lock = 1 WHERE id = @temp
SET @id = @temp
SET @rt = 1
END
ELSE
SET @rt = -1GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货