Monday, 2 April 2012

To insert the table values from other machine in SQL Server

--Port the table values from destination machine to local machine
insert into fb_shopdishdetails
select * from openrowset('sqloledb','192.168.0.13';'sa';'development','select * from adminv2.dbo.fb_shopdishdetails')a

No comments:

Post a Comment