DB variable Name

[VICKEL1]

I have a 3 part DB naming convention such as

DB1.dbo.client

Is there any way to make the first part into a variable such as;

DECLARE @DB as varchar(20)
SET @DB = 'DB1'

SELECT * FROM @DB + '.dbo.client'

Any help would be appreciated

 

[JamesLean]

Only using dynamic SQL:

DECLARE @db varchar(20),
  @sql varchar(1000)

SET @db = 'mydb'
SET @sql = 'SELECT * FROM ' + @db + '.dbo.table'

EXEC(@sql)

--James