游标

DECLAREmy_cursor CURSOR FORSELECT MXGuid FROM SaleDetail WHERE 流水号=@流水号OPEN my_cursorFETCH NEXT FROM my_cursor INTO @Sal

flyingdream123

463人浏览 · 2011-08-15 17:01:23

flyingdream123 · 2011-08-15 17:01:23 发布

DECLARE  my_cursor CURSOR FOR
            SELECT MXGuid FROM SaleDetail WHERE 流水号=@流水号
OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @SaleDetailId
  WHILE @@FETCH_STATUS = 0
    BEGIN
      

      DELETE SaleDetail WHERE MXGuid=@SaleDetailId
      FETCH NEXT FROM my_cursor INTO @SaleDetailId
    END
CLOSE my_cursor 
DEALLOCATE my_cursor

AI编程社区

汇聚全球AI编程工具，助力开发者即刻编程。

更多推荐