Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Romania
    Posts
    4

    Unanswered: Table name in a stored procedure

    How can be used in a stored procedure the name of a table that was passed as a varchar parameter? The table name must be used in the "from" clause of a "select" statement without calling the "EXECUTE" or "sp_executesql". Is it possible?
    Marius G.

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Table name in a stored procedure

    Originally posted by gutoim
    How can be used in a stored procedure the name of a table that was passed as a varchar parameter? The table name must be used in the "from" clause of a "select" statement without calling the "EXECUTE" or "sp_executesql". Is it possible?
    Marius G.
    As far as my knowlege goes, u can do it only using dynamic queries, and for that u'll have to use sp_executesql.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Table name in a stored procedure

    Originally posted by gutoim
    How can be used in a stored procedure the name of a table that was passed as a varchar parameter? The table name must be used in the "from" clause of a "select" statement without calling the "EXECUTE" or "sp_executesql". Is it possible?
    Marius G.
    No
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •