用存储过程操作删除主从表记录，操作成功提交事务，失败回滚操作，避免删除异常误删数据。 . (@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 (select lcid from lightingcontrol where customerid=@fromcustomerid)alarm rxparam device comfort cctvgroup cctv area comfortrx ;;
view code  
，