22,210
社区成员
发帖
与我相关
我的任务
分享
EXEC sp_MsForeachdb
@command1 = N'
USE ?
EXEC sp_MsForeachtable
@command1 = N''PRINT ''''$'''' '',
@replacechar = N''$''
'
exec sp_msforeachTable ' select * from ?'--表
exec sp_msforeachdb ' use [?] select * from sysobjects'--庫
declare @db as varchar(10)
set @db = '...'
exec('use ' + @db)
declare @db as varchar(10)
declare @sql as varchar(100)
set @db = '...'
set @sql = 'use ' + @db
exec(@sql)