初学者问一个简单的SQL问题,莫笑
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
IF EXISTS (SELECT TOP 1 Id INTO @temp FROM tb_free_id WHERE lock = 0)
BEGIN
UPDATE tb_free_id SET lock = 1 WHERE id = @temp
SET @id = @temp
SET @rt = 1
END
ELSE
SET @rt = -1
GO
提示:
在关键字 'INTO' 附近有语法错误。
对象名 'get_free_id' 无效。
这是因为什么地方错了?
问题点数：50、回复次数：3Top
1 楼WindYou（WindYou）回复于 2005-04-03 17:47:57 得分 0
冒人理我?Top
2 楼631799（杭州工人）回复于 2005-04-03 17:49:42 得分 50
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 = -1
GOTop
3 楼WindYou（WindYou）回复于 2005-04-03 17:52:18 得分 0
谢谢,但是为什么我那样不行呢?Top
