Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query with tables from different databases
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01517589
Message ID:
01517602
Vues:
35
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform