javierpdx
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim
ASKER