SQL programming: Stored Procedure + transaction processing + rollback + data migration

Problem description:

Recently, I am working for a school. NET website, called the process-based score Entry System of wenzheng University. The old User Login system needs to import existing data from the old system to the new data table,

USE [new_wzjw] GO/****** Object: StoredProcedure [dbo]. [Score Management _ process Score Input _ data migration] Script Date: 22:55:38 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate proc [dbo]. [Score Management _ process Score Input _ data migration] @ kcId jxrw_code/* Custom variable name */asbeginbegin trybegin tranINSERT INTO [web_inputCj_xsxkb] ([xh], [xm], [xxxzdm], [xxxzmc], [cjxzdm], [kcid], [lrsj], [manuAdd]) select xh, xm, xxxzdm, xxxzmc, cjxzdm, kcid, lrsj, manualAdd from web_inputCj_cjb as a where. kcId = @ kcId and not exists (select * from web_inputCj_xsxkb as B where. xh = B. xh and. kcId = B. kcid) commit tranreturn 0end trybegin catchrollback tranreturn 1end catchend