Ordinamento dati in SQL Server 2005

USE tempdb;

CREATE TABLE dbo.Articoli(
CodArticolo varchar(6) COLLATE Latin1_General_CI_AS NOT NULL,
CONSTRAINT PK_Articoli PRIMARY KEY(CodArticolo)
);

INSERT dbo.Articoli VALUES('ART-01');
INSERT dbo.Articoli VALUES('ART-02');
INSERT dbo.Articoli VALUES('ART01');
INSERT dbo.Articoli VALUES('ART02');

SELECT *
FROM dbo.Articoli
ORDER BY CodArticolo;

/* Output:

CodArticolo
-----------
ART01
ART-01
ART02
ART-02

(4 row(s) affected)

*/

ALTER TABLE dbo.Articoli
DROP CONSTRAINT PK_Articoli;
 
ALTER TABLE dbo.Articoli
ALTER COLUMN CodArticolo varchar(6)
COLLATE Latin1_General_BIN NOT NULL;

ALTER TABLE dbo.Articoli
ADD CONSTRAINT PK_Articoli PRIMARY KEY(CodArticolo);

SELECT *
FROM dbo.Articoli
ORDER BY CodArticolo;

/* Output:

CodArticolo
-----------
ART-01
ART-02
ART01
ART02

(4 row(s) affected)

*/

DROP TABLE dbo.Articoli;