|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
30/03/2008, 07h25
|
#1 (permalink) |
Messages: n/a
Hébergeur: |
RE: querying different databases
DBName must be in the format of [SERVERNAME].[DATABASENAME].DBO.[TABLENAME]..
i hope this will you! "a@b.com" wrote: > Hi, > > I need to query different databases. Below is an example (the database > name is returned in 'select dbname'): > > select dbname, > (select count(*) from [dbname].dbo.members) as 'mycount' > from databases > > Can someone with the syntax of the middle line in the query > please? > > |
|
 |
| Outils de la discussion | |
|
|
