论坛 › SQL Server › SQL SERVER 动态、跨库语句

ABKYH 发表于 2016-10-30 04:01:09

SQL SERVER 动态、跨库语句

　　execute sp_executesql
          N'select * from pubs.dbo.employee where job_lvl = @level',
          N'@level tinyint',
          @level = 35
　　GO
　　
　　declare @num_a int,   
          @num_b int,     
          @sqls nvarchar(4000)
　　
set @sqls='select @a=count(*),@b=count(*) from t_user '
　　exec sp_executesql @sqls,N'@a int output,@b int output',@num_a output,@num_b output
select @num_a,@num_b
　　
　　GO
　　
　　-------------------------------------------------------------------------
　　
　　EXEC sp_addlinkedserver 'OracleSvr',
   'Oracle 7.3',
   'MSDAORA',
   'ORCLDB'
GO
　　
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO
　　
　　-------------------------------------------------------------------------
　　
　　USE pubs
GO
SELECT a.*
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
   'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a
GO
　　
　　USE pubs
GO
SELECT a.*
FROM OPENROWSET('MSDASQL',
   'DRIVER={SQL Server};SERVER=seattle1;UID=sa;PWD=MyPass',
   pubs.dbo.authors) AS a
ORDER BY a.au_lname, a.au_fname
GO
　　
　　

查看完整版本: SQL SERVER 动态、跨库语句