This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › SQL Server creates a new connection server, cross-server operations ...
View: 1|Reply: 0

[Tips] Create a new SQL Server connection server and operate across servers

[Copy link]
Posted on4 seconds ago | | | |
Requirement: A and B are two different SQL Server servers. Server A wants to join a table on Server B to perform a concatenated query.

SQL Server data manipulation between different server databases
https://www.itsvse.com/thread-3445-1-1.html
Create a remote server connection. The SQL command is as follows:
As shown below:



If an error occurs during executionErrors during the decryption process. There is no remote user 'sa' mapped from the remote server 'XXXXXX' to the local user '(null)'.", the repair command is as follows:
Cross-server execution of query operations and test statements:
As shown below:



Other commands:
Reference:

The hyperlink login is visible.
The hyperlink login is visible.




Previous:ASP.NET Core (36) uses Scalar instead of Swagger to display API documentation

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com