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 在试试
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 winidGO
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
在试试
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 winidGO