Is there a difference between default sort order for a select query in SQL 2005 and SQL 2012? I have a table variable with no primary key. When I give a select query on the table variable in SQL 2005, the records are selected and displayed in Alphabetical order as per one of the columns. In SQL 2012, the records are displayed in the same order as in the parent table.
Aucun commentaire:
Enregistrer un commentaire