Regarding pro* c select statement

• rkumar.shran

  Newbie

  Points: 3

  More actions

  May 14, 2008 at 5:31 am

  #71266

  hi..

  I want to use variable name which contain table name into select statement.

  like

  select *from test001_emp;

  instead of this I want to use in this way

  name="test001_emp"

  select *from name;

  how should solve this prob??If u have any sol. then plz tell me

• Michael Meierruth

  SSChampion

  Points: 10051

  More actions

  May 14, 2008 at 6:13 am

  #815086

  Lookup sp_executesql in the BOL.

  For example:

  declare @s-2 nvarchar(4000)

  set @s-2='select * from sysobjects'

  exec sp_executesql @s-2

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  May 14, 2008 at 6:23 am

  #815097

  This is a common beginners' request. You should get to grips with the following article to give you an idea of what you might be getting into...

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

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.