SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table nums ( 
  greater_than_two int not null check (greater_than_two > 2)
);
create or alter proc make_nums_from_list (@list varchar(100))
as
select [value]
into #nums
from string_split(@list,',') 
where try_cast([value] as int) is not null;

begin tran;
begin try 
  insert nums (greater_than_two) 
  select [value]
  from #nums;
  
  commit tran;
  
  return;
end try
begin catch
  rollback tran;
end catch
create or alter proc wrapper (@text varchar(100))
as
exec make_nums_from_list @text;
exec wrapper @text = '3,4,5';

select * from nums;


greater_than_two


3

4

5


exec wrapper @text = '1,2,3';

select * from nums; -- dude where's my error?!


greater_than_two


3

4

5


create or alter proc make_nums_from_list (@list varchar(100))
as
select [value]
into #nums
from string_split(@list,',') 
where try_cast([value] as int) is not null;

begin tran;
begin try 
  insert nums (greater_than_two) 
  select [value]
  from #nums;
  
  commit tran;
  
  return;
end try
begin catch
  rollback tran;
  
  throw; -- helpful throw is helpful
end catch
exec wrapper @text = '1,2,3';

select * from nums; -- dude, THERE's my error :D
Msg 547 Level 16 State 0 Line 10
The INSERT statement conflicted with the CHECK constraint "CK__nums__greater_th__35BCFE0A". The conflict occurred in database "fiddle_89368f804c7646d69de0224a851060e3", table "dbo.nums", column 'greater_than_two'.