Interested to Buy Any Domain ? << Click Here >> for more details...
How to Run a Query on a Remote SQL Server?
- 2 Answers
- 8498 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 |
How to query multiple tables jointly?
How and why use sql server?
How to verify a user name with sqlcmd tool?
Differences between Standby Vs No recovery?
What do u mean by orphan users, how will u list them in the DB
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju
What is query optimization process?
What is the difference RDBMS and Graph Database?
What you can do to delete a table without the delete trigger firing?
How to name query output columns in ms sql server?
How to create an index on a view?
Why use triggers?
-
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)
