Help me.

• Saeed Ahmad

  SSC Veteran

  Points: 208

  More actions

  January 27, 2003 at 3:40 am

  #79446

  Hi,

  Look at following, it works fine.

  declare @EmpName varchar(50)

  declare @DBName varchar(50)

  select @DBName='EmpDB'

  SELECT @EmpName=EmpDB..Employee.LName from EmpDB..Employee

  I need to replace hardcoded EmpDB with variable @DBName because at runtime

  it is decided from where to select data. I tried following but it just assigns string

  to @EmpName.

  SELECT @EmpName= @DBName+ '..Employee.LName from ' + @DBName+'..Employee'

  Can somebody help me with any solution or workaround

  Thanks in anticipation

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 27, 2003 at 4:44 am

  #447258

  You need dynamic sql to make it work. Build your query and assign to a variable - typically @sql but it doesn't matter, then execute using either Exec(@SQL) or sp_executesql (@SQL).

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  January 27, 2003 at 4:47 am

  #447259

  Try

  declare @EmpName varchar(50)

  declare @DBName varchar(50)

  declare @sql nvarchar(1000)

  set @DBName='EmpDB'

  set @sql = 'SELECT @EmpName=LName from '+@DBName

  exec sp_executesql @sql,N'@EmpName varchar(50) output',@EmpName output

  Far away is close at hand in the images of elsewhere.
  Anon.