Answer / kalyana chakravarthy maddipati

You can make a remote connection in a database using DBLINK(Database link). it is a named object in the database.
To create a DBLINK this is the syntax

Create dblink XX(DBLInk Name) connect to USERNAME identified by PASSWORD using DATABASENAME.

To access data from remote place using DBLink this is the way

select * from table_name@xx(DBLink name).

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

How do you persist objects, permissions in tempdb

1 Answers  

---

Does table partitioning improve performance?

0 Answers  

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

How do SQL server 2000 and XML linked?

2 Answers  

---

Can primary key be null?

0 Answers  

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

How to run sql server 2005 books online on your local system?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

How to execute function in stored procedure sql server?

0 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

What is a view?

6 Answers  

---