关于存储过程！

[yyzzff]

以下丰存储过程，我在查询分析器里试过了，可以运行！但在表中用SQL语句试却报错说WINID附近有错，请各位看看是不是有什么问题，为什么会在查询分析器里能行，在SQL中却不行呢？
CREATE PROCEDURE sodb AS
DECLARE @passwd char(30)
DECLARE winid CURSOR FOR
SELECT passwd FROM gz.dbo.gz_bm
OPEN winid FETCH next FROM winid INTO @passwd WHILE @@fetch_status = 0
BEGIN
insert gz_bm(passwd) values (@passwd)
FETCH next FROM winid INTO @passwd END
CLOSE winid
DEALLOCATE winid
GO

[azsoft]

少了while

[azsoft]

对不起。
看错了

[BlackCodeBoy]

可能你的passwd 字段是主键！
不是主键的话你声明的游标没有筛选条件这样会造成死循坏！

[smallroad]

CREATE PROCEDURE sodb AS
DECLARE @passwd char(30)
DECLARE winid CURSOR FOR
SELECT passwd FROM gz.dbo.gz_bm
OPEN winid
FETCH next FROM winid INTO @passwd
WHILE @@fetch_status = 0
BEGIN
insert gz_bm(passwd) values (@passwd)
FETCH next FROM winid INTO @passwd
END
CLOSE winid
DEALLOCATE winid
GO
在试试

[hglhyy]

CREATE PROCEDURE sodb
AS
DECLARE @passwd char(30)
DECLARE winid CURSOR FOR
SELECT passwd FROM gz.dbo.gz_bm
OPEN winid FETCH next FROM winid
INTO @passwd WHILE @@fetch_status = 0

BEGIN
insert gz_bm(passwd) values (@passwd)
FETCH next FROM winid INTO @passwd
END
CLOSE winid
DEALLOCATE winid

GO

[yyzzff]

执行成功了，可是数据库里的数据没有改变，这是为了什么！