Pra mim Basta fazer isso que resolve
CREATE TABLE TabelaTeste
(
TransactionID int NOT NULL,
CONSTRAINT AK_TransactionID UNIQUE(TransactionID)
);
--Insertes de teste
INSERT INTO Teste
( TransactionID )
VALUES ( Null -- TransactionID - int
)
INSERT INTO Teste
( TransactionID )
VALUES ( 1 -- TransactionID - int
)
INSERT INTO Teste
( TransactionID )
VALUES ( 1 -- TransactionID - int
)
INSERT INTO Teste
( TransactionID )
VALUES ( 2 -- TransactionID - int
)
Wesley Neves