MSSQL:用opendatasource增删改查SQLSERVER



要点：

1、".dbo."这个不能少！

2、用opendatasource方法时，不需要用sp_addlinkedserver提前建立链接数据库

1、查

select * from opendatasource('sqloledb','data source=192.168.1.104;user id=sa;password=').db_2008.dbo.test

2、增

insert into opendatasource('sqloledb','data source=192.168.1.104;user id=sa;password=').db_2008.dbo.test values(10,'王进','财务部',800)

3、删

delete opendatasource('sqloledb','data source=192.168.1.104;user id=sa;password=').db_2008.dbo.test  where 员工姓名='王进'

4、改

update opendatasource('sqloledb','data source=192.168.1.104;user id=sa;password=').db_2008.dbo.test set 销售业绩=888 where 员工姓名='王进'