=IF(MOD(ROW(),3)=1,INDEX(Sheet1!A:A,(ROW()⼀3)*6-1),"")请解释

2025-06-28 14:31:55
推荐回答(2个)
回答1:

将sheet1A列的1,7,13...单元格内容填入本列1,4,7...行

回答2:

PRSDBLOGAffectedRowCount @PackageType,1350,@@RowCount
while @@rowcount>1
delete
from temp
OUTPUT deleted.*
INTO temp_deleted
WHERE OperateTime > @CurrentDate
exec PRSDBLOGAffectedRowCount
set rowcount 0