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 are the 2 types of classifications of constraints in the sql server?
explain different types of jions with examples briefly?
How would you Update the rows which are divisible by 10, given a set of numbers in column?
What is the purpose of self join?
How do I setup a local sql server database?
I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.
Explain nested trigger in sql?
How to count groups returned with the group by clause in ms sql server?
What is the filtered index?
how to know description of a table in sqlserver 2000
Can you explain different types of locks in sql server?
what is a join and explain different types of joins? : Sql server database administration