Answer / meenakshi

we can link database If both the DBs are on same Server and
the current user have access permission on both database
then you can use the following query..

Select SomeColumns From CurrentDBName..TableName
Select SomeColumns From OtherDBName..TableName

If the databases are on different Server then you have to
use the Linked Server..

EXEC sp_addlinkedserver @server = 'SERVER', @provider
= 'SQLOLEDB.1', @srvproduct = '', @provstr
= 'Privider=SQLOLEDB.1;Data Source=TargetServer;Initial
Catalog=Database'

go
Exec sp_addlinkedsrvlogin @rmtsrvname = 'SERVER', @useself
= true, @locallogin = null, @rmtuser = 'Userid',
@rmtpassword = 'Password'


On your SP you can use..

Select * From OpenQuery(MyRemoteServer, 'Select * From
Sysobjects')

--OR

Select * From MyRemoteServer.DatabaseName.dbo.Sysobjects

Answer / anil

You can also use curl function for use defferent database

Explain the different types of mysql joins.

0 Answers  

---

What is the use of mysql_fetch_array () function in php?

0 Answers  

---

What is mvcc in mysql?

0 Answers  

---

How do I download a mysql community server?

0 Answers  

---

How do I drop a database in mysql?

0 Answers  

---

What does mysql workbench do?

0 Answers  

---

What is the difference between char and varchar data types?

6 Answers  

---

What is ACID?

2 Answers  

---

How do I truncate all tables in mysql?

0 Answers  

---

What is required to create mysql database?

0 Answers  

---

Is pdo faster than mysqli?

0 Answers  

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---