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

--1.select语句
select *  from  openquery(sqllink, 'select * from hhp_user where chrusername = ''hhp''');
--或
select * from openquery(sqllink, 'select * from hhp_user') where chrusername = @username
 
--2.insert语句，into可省略
insert into openquery(sqllink,'select chrusername,chrpwd from hhp_user where1=0')  values( @username , @pwdmd5)
 
--3.update语句
set @pwd = 'hhp'
set @pwdmd5 = substring(sys.fn_sqlvarbasetostr(hashbytes('md5', @pwd)),3,32)
update openquery(sqllink, 'select chrusername, chrpwd from hhp_user where chrusername = ''hhp''') set chrpwd = @pwdmd5
 
--4.delete语句，from可省略
delete from openquery(sqllink, 'select * from hhp_user where chrusername = ''hhp''')
--或
set @username = 'ls'
delete from openquery(sqllink, 'select * from hhp_user') where chrusername = @username