Link to home
Start Free TrialLog in
Avatar of javierpdx
javierpdxFlag for United States of America

asked on

Alter a table, Order By ASC

Is it possible to add a constraint to a table column that would sort based on date?
I'm using a uniqueidentifer as my primary key, so I want to order by ascending date on SubmitDate column.

ALTER TABLE MyTableName
ADD Constraint ORDER BY (SubmitDate)

SubmitDate is the column name.

I'm using SQL Server.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of javierpdx

ASKER

Thanks.
Thanks for the grade.  Good luck with your project.  -Jim