use variable for the name of a table

• amum

  Grasshopper

  Points: 12

  More actions

  May 21, 2002 at 8:30 am

  #78682

  I want to do this, i don´t know if it is posible

  declare @name_table1

  select * from @name_table1

  I have problems.

  thanks

• Felix

  Newbie

  Points: 9

  More actions

  May 21, 2002 at 8:39 am

  #429531

  you will have to executed the command with EXECUTED()

  declare @name_table1

  select * from @name_table1

  EXEC ('select * from ' + @name_table1

  )

  Felix

• amum

  Grasshopper

  Points: 12

  More actions

  May 21, 2002 at 8:43 am

  #429532

  quote:

  ---

  I want to do this, i don´t know if it is posible

  declare @name_table1

  select * from @name_table1

  I have problems.

  thanks

  I don´t want to use execute

  ---

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 21, 2002 at 9:26 am

  #429533

  Then you'll have to build the sql on the client.

  Andy

  Andy
  Connect with me on LinkedIn

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 21, 2002 at 9:27 am

  #429534

  Andy is right. SQL (at least at this point) does not accept variables for DB, Table or Column name replacement. You will have to use EXEC.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  Edited by - antares686 on 05/21/2002 09:27:45 AM