Delete From 帶 inner join

Delete from Table From Table inner join TableOther On Table.Id=TableOther.Id
注意上面是兩個From

View Code

Declare @rowCount intDeclare @SQL nvarchar(1000)set @rowCount=0Set @SQL=''select @RowCount=count(1) from  KB_Lable_IsScanSyncwhere IsSync=1Set @rowcount=cast( (@RowCount * 2) /3 as int)Set @SQL=' Delete From KB_Lable_IsScanSync  From KB_Lable_IsScanSync s inner join   (    select top '+ cast(@rowCount as nvarchar(50))+' RecId from KB_Lable_IsScanSync    where IsSync=1    order by RecId    ) as t on t.RecId=s.RecId'Exec(@SQL)