TAblename as parameter to the stored procedure

• murali krishna-491058

  Grasshopper

  Points: 23

  More actions

  September 17, 2007 at 1:12 pm

  #153833

  create PROCEDURE [dbo].[test]

  (@age varchar)

  AS

  BEGIN

  select * FROM @age

  END

  can we do something like this....this gives me an error in sql server 2005, so if anyone is aware of doing this kinds thing do let know. i appreciate ur help.

  thanks

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  September 17, 2007 at 1:28 pm

  #734144

  Common question.

  The question is why would want to do this.

  This article basically talks about it

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=245273