openquery

SqlServer调用OPENQUERY函数远程执行增删改查

--1.select语句 select * from openquery(sqllink, 'select * from hhp_user where chrusername = ''hhp'''); --或 select * from openquery(sqllink, 'select * fr ......
函数 SqlServer OPENQUERY

sql 链接服务器openquery查询 带变量+拼接语句

DECLARE @tablename VARCHAR (30), @tablename_1 VARCHAR (30),@tablename_2 VARCHAR (30),@fsc VARCHAR (10), @sql VARCHAR (5000) ,@fsc_1 VARCHAR (10),@fsc_ ......
变量 语句 openquery 链接 服务器
共2篇  :1/1页 首页上一页1下一页尾页