Answer Posted / 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 |
Post New Answer View All Answers
What is right outer join in sql server joins?
What is bcnf normalization form?
What is the use of for clause?
What are ddl (data definition language) statements for tables in ms sql server?
How to end a stored procedure properly in ms sql server?
Please explain what is “asynchronous” communication in sql server service broker?
Mention the uses of stored procedures.
What are various ways to enhance the ssrs report?
How many types of subqueries are there in sql server?
What does truncate do?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is the meaning of sql server?
How do I view a script in sql server?
How to choose all records from the table?
What is the difference between varchar and varchar types?