01.BEGIN TRANSACTION
02.DECLARE @check AS INT
03.
04.SET @check = 0
05.
06.SELECT @check = COUNT(pd.pro_code)
07.FROM product pd
08.INNER JOIN delivery_order_detail do_dt
09.ON pd.pro_code = do_dt.pro_code
10.WHERE pd.pro_code = 'P0018'
11.
12.SELECT @check = COUNT(pd.pro_code)
13.FROM product pd
14.INNER JOIN manufacture_detail m_dt
15.ON pd.pro_code = m_dt.pro_code
16.WHERE pd.pro_code = 'P0018'
17.
18.IF (@check = 0 )
19.BEGIN
20.DELETE product
21.WHERE pro_code = 'P0018'
22.END
23.
24.IF @@ERROR > 0
25.BEGIN
26.ROLLBACK TRANSACTION
27.END
28.COMMIT TRANSACTION
