Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query with tables from different databases
Message
 
 
To
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:
01517602
Views:
34
>>>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?

Could be different, but most likely a dbo. See AdventureWorks sample database, it uses schemas.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform