How to Run a Query on a Remote SQL Server?
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 the difference between functions and scalar functions?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Diffrences between sql server 2000 vs 2005
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
How do I run sql server 2014?
Which are new data types introduced in sql server 2008?
Tell me about builtinadministrator?
What are the basic functions for master, msdb, model, tempdb databases?
Explain the ways to controlling cursor behavior?
write sql program to get the detail of student in a class?
What is difference between clustered and non clustered index?
Explain the etl (extraction, transformation, and loading)?
Oracle (3259)
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)