Answer / Dharmendra Kumar Bharti

A linked server is a feature in SQL Server that allows you to access data from other databases or data sources as if they were local tables. This can be useful for integrating data from multiple sources, such as different databases or Excel files. Here's an overview of how it works:
1. Create the linked server: You define a linked server object that provides the connection information to the remote database.
2. Create a linked server login: You create a login for the remote server, which is used to authenticate the connection.
3. Create views or stored procedures on the local server: You create views or stored procedures that reference the linked server as a source of data.
4. Query the linked server: When you run your query, SQL Server sends the request to the linked server and retrieves the results.

what is foreign key?

5 Answers  

---

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

---

What is the difference between Outer join and Full outer join?

5 Answers  

---

What is analyze command used for?

1 Answers  

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,

---

List out the difference between commit, rollback, and savepoint?

1 Answers  

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1 Answers  

---

What are the different editions of oracle?

1 Answers  

---

Give the various rollback segment states.

1 Answers  

---

what is cartesian product?

2 Answers  

---

How to convert characters to numbers in oracle?

1 Answers  

---