create table tb(id int not null,ItemNo varchar(10) not null) go insert into tb values(1,'aaaa') insert into tb values(2,'bbbb')select * from tbBEGIN TRY insert into tb(id,ItemNo) values(3,'asdfasdf') SELECT 1; END TRY BEGIN CATCH select 0 END CATCH; GOselect * from tb
go
insert into tb values(1,'aaaa')
insert into tb values(2,'bbbb')select * from tbBEGIN TRY
insert into tb(id,ItemNo) values(3,'asdfasdf')
SELECT 1;
END TRY
BEGIN CATCH
select 0
END CATCH;
GOselect * from tb