Sqlserver链接Orcal操作数据语句

SQLServer 连接 Orcal数据库 将SQLServer数据库表中的数据保存到Orcal数据库对应的表中操作语句

查询

select * from openquery(连接服务器名,'select * from orcal.table_name') where...

select name from opquery(lsp,'select * from emp') where age > 20;

删除数据

delete openquery(连接服务器名,'select * from orcal.table_name') where...

delete openquery(lsp,'select * from emp') where name = 'lsp';

插入数据

insert openquery(连接服务器名,'select * from orcal.table_name') select...

declare @name varchar(20)
set @name='test'
insert openqery(lsp,'select * from emp') set name = @name

修改数据

update openquery(连接服务器名,'select * from orcal.table_name') set col=val where...

update openquery(lsp,'select * from emp') set name='xsp' where name='lsp'