Like this?

CREATE TABLE MyTable

(COMCOD SMALLINT,

SIRCODE BIGINT IDENTITY(1802000001000, 1000),

DESCRIPTION VARCHAR(255));

GO

INSERT INTO MyTable (COMCOD, DESCRIPTION)

VALUES

(3306, 'A'),

(3306, 'B'),

(3306, 'c'),

(3306, 'd');

GO

SELECT

*

FROM

MyTable;

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]