SQL Server 2017 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.tblbegintran (age int CHECK (age < 10));
SET IMPLICIT_TRANSACTIONS OFF;
SET XACT_ABORT ON;
INSERT INTO tblbegintran (age)
VALUES (6);
INSERT INTO tblbegintran (age)
VALUES (17);
COMMIT TRAN;
Msg 547 Level 16 State 0 Line 5
The INSERT statement conflicted with the CHECK constraint "CK__tblbegintra__age__35BCFE0A". The conflict occurred in database "fiddle_70c1aa3372344ec49d39cd93d57d7f8a", table "dbo.tblbegintran", column 'age'.

SET IMPLICIT_TRANSACTIONS OFF;
BEGIN TRANSACTION;
INSERT INTO tblbegintran (age)
VALUES (7);
INSERT INTO tblbegintran (age)
VALUES (17);
COMMIT TRANSACTION;
Msg 547 Level 16 State 0 Line 5
The INSERT statement conflicted with the CHECK constraint "CK__tblbegintra__age__35BCFE0A". The conflict occurred in database "fiddle_70c1aa3372344ec49d39cd93d57d7f8a", table "dbo.tblbegintran", column 'age'.

SET IMPLICIT_TRANSACTIONS ON;
INSERT INTO tblbegintran (age)
VALUES (8);
INSERT INTO tblbegintran (age)
VALUES (17);
COMMIT TRANSACTION;
Msg 547 Level 16 State 0 Line 4
The INSERT statement conflicted with the CHECK constraint "CK__tblbegintra__age__35BCFE0A". The conflict occurred in database "fiddle_70c1aa3372344ec49d39cd93d57d7f8a", table "dbo.tblbegintran", column 'age'.

SELECT * --Only 6 appears
FROM dbo.tblbegintran;


age


6


DROP TABLE dbo.tblbegintran;