Interested to Buy Any Domain ? << Click Here >> for more details...
How to Run a Query on a Remote SQL Server?
- 2 Answers
- 8606 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinod
By Using linked server we can get data from remote servers, and we can fire a query on remote server. we need to use three part naming conventions for this.
servername.databasename.dbo.tablename
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
Use the OpenRowSet Function to Run a Query on a Remote SQL
Server.
| Is This Answer Correct ? | 1 Yes | 4 No |
What is partition index in sql server?
Explain what is the difference between a local and a global temporary table?
How to use "begin ... End" statement structures in ms sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Explain what you mean by 3 tier architecture.
What are scalar functions?
What is the basic difference between clustered and a non-clustered index?
write an SQL query to list the employees who joined in the month of January?
How do I connect to sql server database?
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain what is meant by replication of database?
Does partitioning improve performance?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
