Parameter passed to a stored procedure

• mipo

  Ten Centuries

  Points: 1346

  More actions

  June 11, 2002 at 3:25 pm

  #78464

  I am having a rather silly question regarding passing over a parameter holding a table name which will be used within the stored procedure.

  What is the correct syntax for that example:

  DECLARE @TableName varchar (50)

  SELECT @TableName = 'Statisctics'

  Select * from '@TableName'

  gives me always syntax error!

  Thanks

  Mipo

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 11, 2002 at 6:08 pm

  #430697

  Wont work like that, you have to build up a string, then use exec() or sp_executesql, like this:

  set @sql='select * from ' + @tablename

  exec(@sql)

  Andy

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

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter