|
Re: Copy data from different SQL Server using TSQL
-
12-17-2008, 8:33 PM |
|
-
B_gd_n[ ]Sahlean
-
-
-
Joined on 07-17-2007
-
Bucuresti
-
sysadmin
-
-
|
Re: Copy data from different SQL Server using TSQL
plus - OPENDATASOURCE
- OPENROWSET
- OPENQUERY
Exemplu BOL: SELECT * FROM OPENDATASOURCE ( 'SQLOLEDB', 'Data Source=ServerName;User ID=MyUID;Password=MyPass' ).Northwind.dbo.Categories
|
|
View Complete Thread
|
|
|