介绍了SQL cursor用法实例，有需要的朋友可以参考一下

代码如下:DECLARE OldId varchar(50)   DECLARE CustomerID varchar(50)   DECLARE My_Cursor CURSOR –定义游标   FOR (select CustomerID,oldid from Customer where Area=’bj’) –查出需要的集合放到游标中   OPEN My_Cursor; –打开游标   FETCH NEXT FROM My_Cursor INTO CustomerID,OldId; –读