var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
is there any possiblity to run a select statement against the tables of two different databases which are both installed on the same database server ? Does anybody know how to join those tables reasonable way ?
from db1.dbo.table1 t1 inner join db2.dbo.table2 t2
on t1.pk = t2.pk
Use Linked Servers concept and BOL is your friend.
Microsoft SQL Server MVP
Linked servers unnecessary since both dbs on same server.
If it's not practically useful, then it's practically useless.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors