Interested to Buy Any Domain ? << Click Here >> for more details...
How to Run a Query on a Remote SQL Server?
- 2 Answers
- 8469 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 |
explain how to create a new schema in a database? : Sql server database administration
What is mean by candidate key?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
How do we get month name in SQL Server 2000, Oracle, MS Access?
What is sparse columns of sql server 2008?
What are some examples of schemas?
Write a query to get all details of employee who has maximum salary from employee table
Explain system views?
What is SubQuery in SQL Server 2008
-
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)
