DECLARE @olnID int
DECLARE crx CURSOR LOCAL FAST_FORWARD FOR
WITH oln_tree AS
(
select id from table_1
)
select id from oln_tree
OPEN crx
FETCH NEXT FROM crx INTO @olnID
WHILE @@FETCH_STATUS = 0
BEGIN
select @olnID
--call sp EXECUTE dbo.spBAS_delOrderLines @olnID = @olnID
FETCH NEXT FROM crx INTO @olnID
END
CLOSE crx
DEALLOCATE crx
CTE 中用游标的方法
最新推荐文章于 2022-06-18 13:37:36 发布