Create Index in TSQL using ASC | DESC

• Parvez

  SSC Journeyman

  Points: 91

  More actions

  February 25, 2003 at 11:35 am

  #79772

  Can anybody tell me how to create index on any column in DESC order. I need the syntex

  let's say ...

  CREATE nonCLUSTERED INDEX index_by_Returned_Date

  ON finaltable (Returned_Date)

  please modify it

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  February 25, 2003 at 12:18 pm

  #449726

  Try this out:

  CREATE nonCLUSTERED INDEX index_by_Returned_Date

  ON finaltable(Returned_Date DESC)

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP