且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在存储过程中编写连接字符串

更新时间:2023-11-07 19:52:58

请参阅SQL Server帮助文件中的以下主题:

* OPENDATASOURCE(Transact-SQL)



示例:

See the following topic in the SQL Server Help file:
* OPENDATASOURCE (Transact-SQL)

Example:
SELECT * FROM 
OPENDATASOURCE(
'SQLNCLI','Data Source=London\Payroll;Integrated Security=SSPI'
).AdventureWorks2012.HumanResources.Employee





另见文档:

* sp_addlinkedserver(Transact- SQL)

* sp_serveroption(Transact-SQL)



Also see documentation for:
* sp_addlinkedserver (Transact-SQL)
* sp_serveroption (Transact-SQL)