在SQL中向多个数据库中插入相同的记录?

[torrent2008]

想通过游标的方式来控制
标位置数据库的名称
select name from master.dbo.sysdatabases where name like 'zw%'
zw0001
zw0002
zw0003
zw0004
.......

来获取数据库名称列表
---
插入的记录为
insert into gl_gnqx (userid,gnid)
values('2','471')

用T-SQL语句写
XX

[pbsql]

declare @db varchar(50)
declare c cursor for
select name from master.dbo.sysdatabases where name like 'zw%'
open c
fetch next from c into @db
while @@fetch_status=0
begin
exec('use '+@db
+' insert into gl_gnqx (userid,gnid) values(''2'',''471'')')
fetch next from c into @db
end
close c
deallocate c

[pjjia]

----声明游标
declare @name varchar(40)
declare c_database cursor
for select name from master.dbo.sysdatabases where name like 'zw%'

---打开
open c_database
fetch next from c_database into @name
fetch next from c_database into @name
select @name = @name+'.dbo.gl_gnqx'
insert into @name (userid,gnid) values('2','471')

while @@FETCH_STATUS = 0
begin
fetch next from c_database into @name
select @name = @name+'.dbo.gl_gnqx'
insert into @name (userid,gnid) values('2','471')
end
--
close c_databse
deallocate c_database
go

[torrent2008]

declare @db varchar(50)
声明变量一定要在游标之前吗/

open c_database
fetch next from c_database into @name
fetch next from c_database into @name
要输入2遍吗/

while @@FETCH_STATUS = 0
什么意思/

[torrent2008]

ding

[pbsql]

看1楼的

[torrent2008]

ding
----
可以帮我回答如上问题吗/

[sunriver]

while @@FETCH_STATUS = 0
是指还有数据可取,读到最后一条时@@FETCH_STATUS = -1

declare @db varchar(50)
变量在使用前定义即可