Getting THE DBName and the Server name From the Table

• jyoti khera

  SSC Rookie

  Points: 45

  More actions

  October 6, 2005 at 1:04 am

  #89570

  Hi,

  For any SQL query ,Can i get the name of the database and the server name from the table and put that in The FROM clause

  something like..

  Select * as DBName from Table1

  set @DBname =DBName

  Select * from @DBName

   

  Or can u suggest the way of getting the DBName and the Server name dynamically and then running the SQLQuery

  Regards

  Jyoti

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  October 6, 2005 at 1:34 am

  #595346

  select db_name() - this gets you the name of the current database context

  select @@servername - this gets you the name of the server

• Norene Malaney

  SSCommitted

  Points: 1896

  More actions

  October 7, 2005 at 7:56 am

  #595860

  Here's a working example that executes a 'select *' on dbo.Table:

  DECLARE @SQLString nvarchar(100)

  set @SQLString = N'select * from '+ @@servername + '.' + db_name() + '.dbo.Table'

  PRINT @SQLSTRING

  EXEC(@SQLString)

  ---

  Have a good day,

  Norene Malaney

• Todd Bellaver

  Grasshopper

  Points: 13

  More actions

  October 7, 2005 at 11:55 am

  #595979

  Hi,

  Can these commands be used in VB as well?  Or would you recommend a different method?

  Thanks

  - Beach