34,588
社区成员
发帖
与我相关
我的任务
分享
delete dbo.bk_Circulate where sync_uid='0001.0006.0004.0199' and barcode between '0072124' and '0072275'
select * from dbo.bk_Circulate where sync_uid='0001.0006.0004.0199' and barcode between '0072124' and '0072275'
;WITH temc AS (
SELECT *
FROM dbo.bk_Circulate
WHERE sync_uid = '0001.0006.0004.0199'
AND barcode BETWEEN '0072124' AND '0072275'
)
delete temc