♥單純是種快樂♥

DECLARE @cnt int

set @cnt = (SELECT count(*) as cnt

  FROM testtableA as A

  join testtableB as C on C.ID = A.ID

    join testtableC as B on C.ID = B.ID

where data_YEAR = '2016')

 

if (@cnt > 0)

    delete testtableA

      FROM testtableA as A

      join testtableB as C on C.ID = A.ID

        join testtableC as B on C.ID = B.ID

    where data_YEAR = '2016'

else

     ..... (略）

GO