SQL cross-server database Add, delete, change, check (i)

--enable the operation of other servers in this serverexecsp_configure'Show advanced Options',1 Reconfigure --Output Messageexecsp_configure'Ad Hoc Distributed Queries',1 Reconfigure --Output Message--IncreaseINSERT  into OPENROWSET('SQLOLEDB','JX3XXIEDNR3UCIDF';'SA';'Aa12345', Yyg.dbo.T_Tabel_a) ([Name])VALUES('Zhang Hui')--DeleteDELETE OPENROWSET('SQLOLEDB','JX3XXIEDNR3UCIDF';'SA';'Aa12345', yyg.dbo.T_Tabel_a)WHERE [Name] = 'Zhang Hui'     --ChangeUPDATE OPENROWSET('SQLOLEDB','JX3XXIEDNR3UCIDF';'SA';'Aa12345', yyg.dbo.T_Tabel_a)SET   [Name] = 'Chen Qiu Water' WHEREId= 4--CheckSELECT *  from OPENROWSET('SQLOLEDB','JX3XXIEDNR3UCIDF';'SA';'Aa12345', Yyg.dbo.T_Tabel_a)--turn off the ability to operate other servers in this serverexecsp_configure'Ad Hoc Distributed Queries',0 Reconfigure  --Output Messageexecsp_configure'Show advanced Options',0 Reconfigure --Output Message--Description: SELECT * from OPENROWSET (' SQLOLEDB ', ' Server '; ' Account (Database account) '; ' Password (database password) ', yyg.dbo.T_Tabel_a)

SQL cross-server database Add, delete, change, check (i)