关于存储过程!
以下丰存储过程,我在查询分析器里试过了,可以运行!但在表中用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