Interested to Buy Any Domain ? << Click Here >> for more details...
How to Run a Query on a Remote SQL Server?
- 2 Answers
- 8600 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 |
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Do you know what are the differences between lost updates and uncommitted dependencies?
Do you know what is rank function?
What is the dbcc command and why is it used?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
what is the system function to get the current user's user id? : Sql server database administration
What is awe?
What are the main sources of data?
Explain about link server in sql server?
What is a primary index?
What is Full Outer Join?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
-
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)
