create proc spInsertTableSQL
as
DECLARE xCursor CURSOR FOR
select String from testdb
declare @F1 varchar(4000)
OPEN xCursor
FETCH xCursor into @F1
WHILE @@FETCH_STATUS = 0
BEGIN
execute @F1
FETCH NEXT FROM xCursor into @F1
END
CLOSE xCursor
DEALLOCATE xCursor
go查询到的 @F1 是条Insert语句,怎么样才能使用!!!
as
DECLARE xCursor CURSOR FOR
select String from testdb
declare @F1 varchar(4000)
OPEN xCursor
FETCH xCursor into @F1
WHILE @@FETCH_STATUS = 0
BEGIN
execute @F1
FETCH NEXT FROM xCursor into @F1
END
CLOSE xCursor
DEALLOCATE xCursor
go查询到的 @F1 是条Insert语句,怎么样才能使用!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货