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 Extended user-defined?
Explain about nested stored procedure?
How to edit table in sql server 2017?
What is the user of Primary key?
What happens if null values are involved in datetime operations?
How to store and query spatial data?
What is normalization of database?
How to set database to be read_only in ms sql server?
How to Update from select query in sql server?
How to create indexed view?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is subquery? Explain the properties of a subquery?
What the different components of Replication and what is their use?
Explain timestamp datatype?
whats new about truncate in sql server 2008?