SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.identitytable(id int identity(1,1), val varchar(255));
INSERT INTO dbo.identitytable(val)
VALUES('BLA1');
1 rows affected

BEGIN TRAN
INSERT INTO dbo.identitytable(val)
VALUES('BLA2');

ROLLBACK TRAN
1 rows affected

INSERT INTO dbo.identitytable(val)
VALUES('BLA3');
1 rows affected

SELECT * FROM dbo.identitytable;


id
val


1
BLA1

3
BLA3


INSERT INTO dbo.identitytable(val)
VALUES(REPLICATE('B',256));
Msg 2628 Level 16 State 1 Line 1
String or binary data would be truncated in table 'fiddle_a2cc1d4e7fab4a61b7993ee1c0d509c2.dbo.identitytable', column 'val'. Truncated value: 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB'.
Msg 3621 Level 0 State 0 Line 1
The statement has been terminated.

INSERT INTO dbo.identitytable(val)
VALUES('BLA5');
1 rows affected

SELECT * FROM dbo.identitytable;


id
val


1
BLA1

3
BLA3

5
BLA5


BEGIN TRAN
INSERT INTO dbo.identitytable(val)
SELECT 'BLA6'
FROM master..spt_values
ROLLBACK TRAN
2540 rows affected

INSERT INTO dbo.identitytable(val)
VALUES('BLA7');
1 rows affected

SELECT * FROM dbo.identitytable;


id
val


1
BLA1

3
BLA3

5
BLA5

2546
BLA7