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 |
Do you know what are the steps to process a single select statement?
What is difference between inner join and join?
What are the two modes of authentication in sql server?
Difference between LEN() and DATALENGTH() in sql server ?
What is transaction ? Give me one example.
What is temporary stored procedure?
how to give input dynamically to a insert statement in sqlserver
What is multi-statement table-value user-defined function?
How to get number of days in a given year?
What are the different type of replication in sql server?
Do you know exporting and importing utility?
can you any body tell me suppose database is suspect mode. how can take to normal?
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)