27,579
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
点点星灯 2005-11-27
- 打赏
- 举报
exec sp_MSforeachdb N'use [?]select dbname=db_name(),username=user_name()'
vivianfdlpw 2005-11-27
- 打赏
- 举报
exec sp_msforeachtable 'print ''?'''
or
declare @cursor cursor
,@name varchar(20)
set @cursor=cursor for select name from sysobjects where xtype='U'
open @cursor
fetch next from @cursor into @name
while @@fetch_status=0
begin
print @name
fetch next from @cursor into @name
end
close @cursor
deallocate @cursor
or
declare @cursor cursor
,@name varchar(20)
set @cursor=cursor for select name from sysobjects where xtype='U'
open @cursor
fetch next from @cursor into @name
while @@fetch_status=0
begin
print @name
fetch next from @cursor into @name
end
close @cursor
deallocate @cursor
