Answer Posted / Mritunjay Kumar Pandey
A Linked Server in SQL Server allows you to access tables on another SQL Server instance or even other data sources like Oracle or Access as if they were local. This enables querying, updating, and executing stored procedures across different databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is temporary table in sql server? Why we use temp table?
What is clustered index
Can we shrink data file in sql server?
What is standby servers? Explain types of standby servers.
Why we use the openxml clause?
How can I check that whether automatic statistic update is enabled or not?
How to connect php with different port numbers?
List the ways in which dynamic sql can be executed?
Disadvantages of the indexes?
What is sql or structured query language?
How can you append an identity column to a temporary table?
Explain “row_number()” in sql server with an example?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What kind of problems occurs if we do not implement proper locking strategy?
