用存储过程操作删除主从表记录,操作成功提交事务,失败回滚操作,避免删除异常误删数据。 . (@parameter1 int = 5,@parameter2 datatype OUTPUT) */ ( @FromCustomerID int , @CustomerType int , @Result int output) LightingControlSceneLevel ParadoxSc
用存储过程操作删除主从表记录,操作成功提交事务,失败回滚操作,避免删除异常误删数据。
.(@parameter1 int = 5,@parameter2 datatype OUTPUT)*/(@FromCustomerID int,@CustomerType int,@Result int output)LightingControlSceneLevel ParadoxScene LightingControlSceneComfort LightingControlSceneStatus LightingControlScene LightingControlCircuit WHERE LCID IN (本文来源gao*daima.com搞@代#码&网6SELECT LCID FROM LightingControl WHERE CustomerID=@FromCustomerID)Alarm RXParam Device Comfort CCTVGroup Cctv Area ComfortRX ;;
View Code
,