how to perform a requet that uses two different data base

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Harveysburger SSCommitted Points: 1562 More actions · Answer 1

both the French and the English questions left me puzzled... I answered the French one

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

Please don't cross post things. We see all the forums.

Once you have called the stored procedure, the output parameter comes out in @d and you can use that in a select as you've done.

select @d, col1, col2

from othertable.

d.m.amine Old Hand Points: 312 More actions · Answer 3

but how there is 2 data base in SQl SERVER 2005 once TOPIC and other POTIC

give me exemple

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

There can be any number of databases in sqlserver.

You have 4 system databases:

-master

-msdb

-model

-tempdb

(you can have some more in a distribution context)

All other databases are user databases.

So you need to connect on one databases like

use mydb1

go

select col1, theothercolumn, ... from theschema.thetable where ...

go

or you can directly adress a table in a database using the database name in the select statement.

select col1, theothercolumn, ... from mydb1.theschema.thetable where ...

go

Each db has its own objects, files, filegroups, transaction log(s),...

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this