USE pubs
GO
if exists (select * from sysobjects where name='Clustered_Dupes' and type='U')
DROP TABLE Clustered_Dupes
GO
CREATE TABLE Clustered_Dupes
(Col1 char(5) NOT NULL,
Col2 int NOT NULL,
Col3 char(3) NULL,
Col4 char(6) NOT NULL,
Col5 float NOT NULL)
GO
CREATE CLUSTERED INDEX Cl_dupes_col1 ON Clustered_Dupes(col1)
GO
SELECT first, indid, keycnt, name FROM sysindexes
WHERE id = object_id ('Clustered_Dupes')
GO
INSERT Clustered_Dupes VALUES ('ABCDE', 123, null, 'CCCC', 4567.8)
GO
SELECT first, root, id,indid FROM sysindexes
WHERE id = object_id('Clustered_Dupes')
GO
INSERT Clustered_Dupes VALUES ('ABCDE', 456, null, 'DDDD', 4567.8)
INSERT Clustered_Dupes VALUES ('ABCDE', 64, null, 'EEEE', 4567.8)
GO