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.