Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query with tables from different databases
Message
From
07/07/2011 11:37:53
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01517589
Message ID:
01517595
Views:
38
>>Hello,
>>
>>How can I make a query in SQL server that involves tables from different databases? I tried MyDB!MyTable, but that does not work.
>
>MyDB.dbo.MyTable
>
>(Use 3 parts naming convention - DbName.SchemaName.TableName)

So the SchemaName is always "dbo"? or could that be different sometimes?
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform