Using a declared field in stored procedures to name a table

• gjohnson-521099

  SSC Rookie

  Points: 30

  More actions

  October 17, 2007 at 5:17 pm

  #199236

  does anyone know if it is possible to use a declared field to name a table?

  example

  declare @tablename as char(50)

  select @tablename = nameoftable from

  where tabledisc = 1

  select * from @tablename

• Max Yasnytsky

  SSCrazy

  Points: 2462

  More actions

  October 17, 2007 at 5:34 pm

  #742928

  i would do it like this

  DECLARE @tableName AS varchar (50), @sqlCmd varchar(max)

  SELECT @tableName=nameOfTable

  FROM

  WHERE tabledisc = 1

  SELECT @sqlCmd='SELECT * FROM '+@tableName

  EXEC sp_executesql @sqlCmd

  dynamic SQL is the best choice for this sort of queries

  Here is one of the best article about it

  http://www.sommarskog.se/dynamic_sql.html

• gjohnson-521099

  SSC Rookie

  Points: 30

  More actions

  October 18, 2007 at 5:21 pm

  #743347

  Thanks! the article you referred to had all the information I needed