T-SQL delete 下 join

原來 DEL 也可以下 JOIN XD






DELETE TableA FROM TableA A

JOIN TrableB B(NOLOCK)

ON A.a1 = B.a1 AND A.a2 = B.a2



--
※ 發信站: 批踢踢兔(ptt2.cc)
◆ From: 116.59.237.110