Sqlserver???????????????
???????????? ???????[ 2015/5/13 13:55:15 ] ?????????????
?????????????????????????????????????????????????????????????校?????????????????????Id????
????1?????????????????????校????????????????
????--?????????????
exec sp_addlinkedserver
@server= 'otherdb'?? --?????????????????????????????????IP???
@srvproduct= ''?? --??
@provider='SQLOLEDB'?? --????????
@datasrc = '192.168.1.1' --?????????????IP???????????????????????????????????'192.168.1.1??????'
????--????????????
exec sp_addlinkedsrvlogin
'otherdb'?? --????????????????
'false'??
NULL??
'?????'?? --??? --?????????????????????????????????sa
'????' --????
????2????????
????select id??a??b from table1 union(select id??a??b from [otherdb].[name].dbo.table1 as table2) order by id
??????

???路???
??????????????????
2023/3/23 14:23:39???写?貌??????????
2023/3/22 16:17:39????????????????????些??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???路???????路
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11