Answer Posted / 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

Write command to import an mysql file?

679

---

What does mysql flush hosts do?

648

---

What is dump in mysql?

635

---

What are date and time data types?

707

---

what is constraints? Also explain the different types of constraints?

701

---

what is the default port for mysql server? : Mysql dba

735

---

How to run a sql statement?

732

---

What is a storage engine?

707

---

Can we store videos in mysql database?

690

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

705

---

Is mysql an oracle product?

652

---

How to use sum function in where clause in mysql?

682

---

How do you create a new database in mysql?

648

---

What is row locking in mysql?

716

---

What is mysql and mysqli?

648

---