62,046
社区成员
发帖
与我相关
我的任务
分享
commit tran
update tbl_lecense_number set product_id=@product_id,productInfo_id=@productInfo_id,number=@number_1967 , number_name=@number_name_1967, number_note=@number_note_1967, deadline=@licenseDeadline_1967, date=@date_1967, readyImg=@ready_1967, designTeam=@designTeam_1967, dropDown=@dropDown_1967,cat=@cat_1967,productMilestones_id=@productMilestones_id_1967 where serial=@licenseId_1967;
update tbl_lecense_number set product_id=@product_id,productInfo_id=@productInfo_id,number=@number_2159 , number_name=@number_name_2159, number_note=@number_note_2159, deadline=@licenseDeadline_2159, date=@date_2159, readyImg=@ready_2159, designTeam=@designTeam_2159, dropDown=@dropDown_2159,cat=@cat_2159,productMilestones_id=@productMilestones_id_2159 where serial=@licenseId_2159;
update tbl_lecense_number set product_id=@product_id,productInfo_id=@productInfo_id,number=@number_2148 , number_name=@number_name_2148, number_note=@number_note_2148, deadline=@licenseDeadline_2148, date=@date_2148, readyImg=@ready_2148, designTeam=@designTeam_2148, dropDown=@dropDown_2148,cat=@cat_2148,productMilestones_id=@productMilestones_id_2148 where serial=@licenseId_2148;
update tbl_lecense_number set product_id=@product_id,productInfo_id=@productInfo_id,number=@number_2151 , number_name=@number_name_2151, number_note=@number_note_2151, deadline=@licenseDeadline_2151, date=@date_2151, readyImg=@ready_2151, designTeam=@designTeam_2151, dropDown=@dropDown_2151,cat=@cat_2151,productMilestones_id=@productMilestones_id_2151 where serial=@licenseId_2151;
update tbl_lecense_number set product_id=@product_id,productInfo_id=@productInfo_id,number=@number_2155 , number_name=@number_name_2155, number_note=@number_note_2155, deadline=@licenseDeadline_2155, date=@date_2155, readyImg=@ready_2155, designTeam=@designTeam_2155, dropDown=@dropDown_2155,cat=@cat_2155,productMilestones_id=@productMilestones_id_2155 where serial=@licenseId_2155;
update tbl_lecense_number set product_id=@product_id,productInfo_id=@productInfo_id,number=@number_2158 , number_name=@number_name_2158, number_note=@number_note_2158, deadline=@licenseDeadline_2158, date=@date_2158, readyImg=@ready_2158, designTeam=@designTeam_2158, dropDown=@dropDown_2158,cat=@cat_2158,productMilestones_id=@productMilestones_id_2158 where serial=@licenseId_2158;
begin tran
开头 和结尾加一个 commit tran 和 begin tran