Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain what is the difference between union and union all?
Can We Use Data-grids For Our Report In Ssrs?
Can a synonym name of a table be used instead of a table name in a select statement?
What is difference between primary key and foreign key?
Is the primary key column of a table an index in ms sql server?
what is the difference between openrowset and openquery?
Mention the differences between having and where clause.
How can you know if the row fetched from cursor is still valid in underlying table?
What is merge replication?
What does REVERT do in SQL Server 2005?
What is the maximum size of a dimension? : sql server analysis services, ssas
What will be query used to get the list of triggers in a database?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to insert multiple rows with one insert statement in ms sql server?
What do mean by xml datatype?
