Sql Server 事务批量执行SQL语句，可以用来排查脚本问题

BEGIN TRAN
BEGIN try

INSERT INTO [szjszx].[dbo].[Table_1] ([IndexNo], [BWMC]) VALUES (N'2', N'2');
INSERT INTO [szjszx].[dbo].[Table_1] ([IndexNo], [BWMC]) VALUES (N'3', N'');

END try
BEGIN catch
select ERROR_LINE() as 错误行
,ERROR_MESSAGE() as 错误信息
if(@@trancount>0) --错误
ROLLBACK TRAN     --回滚到开始
end catch
if(@@trancount>0)
ROLLBACK TRAN