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).

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

what is sql injection in sql server?

2 Answers   TATA,

---

What is the difference between varchar and varchar types?

0 Answers  

---

What are the types of table?

0 Answers  

---

How do I know if localdb is running?

0 Answers  

---

What to check if a User database is locked?

0 Answers   TCS,

---

How do you know if sql server is running on your local system?

0 Answers  

---

What is the use of nvl work?

0 Answers  

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

whats the maximum size of view state??

0 Answers  

---

What are different types of statement?

0 Answers  

---