passing column name to stored procedure

• szopdog

  Old Hand

  Points: 333

  More actions

  March 3, 2003 at 7:33 am

  #80457

  Does anyone know how to do that?

  Would you please enlighten me if you do?

• Hans Lindgren

  SSChampion

  Points: 10494

  More actions

  March 3, 2003 at 10:05 am

  #450138

  What do you mean exactly?

  Pass it to your stored procedure as a VARCHAR() and use it in your query with the EXEC sql command.

  Ex for dynamic sql:

  DECLARE @MyColumn AS VARCHAR(80) ; SET @MyColumn = 'name'

  EXEC('SELECT ' + @MyColumn + ' FROM sysobjects')

  Or retrieve the column you want from the table syscolumns

  I hoped that helps.

  Edited by - hanslindgren on 03/03/2003 10:07:12 AM