I have two sql database at different PC.how can link b/w
database and database tables.

Answers were Sorted based on User's Feedback



I have two sql database at different PC.how can link b/w database and database tables...

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

Is This Answer Correct ?    9 Yes 4 No

I have two sql database at different PC.how can link b/w database and database tables...

Answer / anil

You can also use curl function for use defferent database

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do we use % when performing a search query?

0 Answers  


Does insert statement lock the table?

0 Answers  


Which software is used for mysql?

0 Answers  


What is 'mysqlshow'?

0 Answers  


How do I install mysql workbench?

0 Answers  


What does do in mysql?

0 Answers  


Is mariadb faster than mysql?

0 Answers  


Write a program using the select statement, while loop.

0 Answers  


Is foreign key indexed mysql?

0 Answers  


Write a query to display even rows in student table using mysql?

0 Answers  


What is the usage of "i-am-a-dummy" flag in mysql?

0 Answers  


Can mysql store files?

0 Answers  


Categories