sortcolumn And SortOrder

• vinaseetha87

  SSC Veteran

  Points: 268

  More actions

  June 20, 2011 at 12:53 am

  #253162

  Stored Procedure -How to Pass @SortColumn And @SortOrder

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  June 20, 2011 at 2:40 am

  #1341006

  vinaseetha87 (6/20/2011)

  ---

  Stored Procedure -How to Pass @SortColumn And @SortOrder

  I did not understand your question correctly. Stilly try to reply with.

  Syntax:

  EXEC dbo.spStoredProcedureName @SortCOlumn = 'ColumnName', @SortOrder = 'SortOrder'

  For example:

  EXEC dbo.spAddressList @SortCOlumn = 'City', @SortOrder = 'ASC'

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 20, 2011 at 11:37 am

  #1341349

  vinaseetha87 (6/20/2011)

  ---

  Stored Procedure -How to Pass @SortColumn And @SortOrder

  SQL is a declarative language, i.e. this does not work:

  DECLARE @SortOrder NCHAR(4),

  @SortColumn SYSNAME ;

  SET @SortOrder = 'ASC' ;

  SET @SortColumn = N'name' ;

  SELECT *

  FROM master.sys.tables

  ORDER BY @SortColumn @SortOrder ;

  Why are you trying to offer this functionality from SQL? Changing the order of results is better left to the presentation layer.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato