create proc temp @dbname
as
declare @sql varchar(4000)
set @sql='select * from '+@dbname+'.dbo.sysobjects'
exec(@sql)
as
declare @sql varchar(4000)
set @sql='select * from '+@dbname+'.dbo.sysobjects'
exec(@sql)
create proc temp(@dbname Varchar(50))
as
declare @sql varchar(4000)
set @sql='select * from '+@dbname+'.dbo.sysobjects'
exec(@sql)
GO使用:temp master
那我隻會一句
exec('use northin')--->轉到數據庫