自己补充一下
update naika set xyhkr=dateadd(Month,1,xyhkr),syl=(a.syl-b.pssl-b.heti),ywjyf=(a.ywjyf+'+'+b.psyf) from naika as a, myts as b where a.id=b.cid and b.id in(8)
UPDATE OPENDATASOURCE(
'SQLOLEDB ',
'Data Source=192.168.1.8;User ID=SA;Password=1111 '
).DBTEST.dbo.student
SET Address = B.Address
FROM
OPENDATASOURCE(
'SQLOLEDB ',
'Data Source=192.168.1.8;User ID=SA;Password=1111 '
).DBTEST.dbo.student as a
,
student AS B
WHERE a.name = b.name and
b.name = 'XXX '
update OPENDATASOURCE(
'SQLOLEDB',
'Data Source=19.48.36.21\kgm;User ID=sa;Password=jihuake'
).fe_base5.dbo.sys_users
set su01=b.su01,su02=b.su02,su04=b.su04 from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=19.48.36.21\kgm;User ID=sa;Password=jihuake'
).fe_base5.dbo.sys_users a,fe_base5..sys_users b
where a.su00=b.su00
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)