update transaction_details set transaction_details.status=3 from transaction_details, commodity_codes where transaction_details.status=2 and transaction_details.item_code=commodity_codes.ahara_commodity_code and bill_no='" + _with1["BillNo"] + "' and transaction_details.trans_date ='" + _with1["Date"] + "'
Begin tran t1 your query 1 your query 2 your query 3 IF (@@ERROR <> 0) BEGIN PRINT 'Unexpected error occurred!' ROLLBACK TRAN RETURN 1 END else BEGIN commit tran t1 end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)