Update with a variable

• fkearney

  SSC Journeyman

  Points: 91

  More actions

  May 24, 2006 at 12:08 pm

  #117734

  I am trying to get a query to work and running into a brick wall

  create procedure set_interface_flag

  @lnkey varchar(20),

  @Tname varchar(25),

  @fname varchar(25)

  as

  update @Tname

  set @fname = getdate()

  where lnkey = @lnkey

  it tells me I need to declare the @Tname variable. Any thoughts?

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  May 24, 2006 at 12:12 pm

  #639874

  You need to use dynamic SQL, it won't automatically parse your table name in.

  create procedure set_interface_flag

  @lnkey varchar(20),

  @Tname varchar(25),

  @fname varchar(25)

  as

  declare @sql nvarchar ( 4000 )

  set @sql = 'update ' + @Tname + '

  set ' + @fname + ' = getdate()

  where lnkey = ''' + @lnkey + '''

  exec sp_executesql @sql