摘要:
DECLARE @TypeId INT, @Price1 FLOAT, @Original FLOAT DECLARE my_cursor CURSOR SCROLL FOR SELECT TypeId,Price1,Original FROM [DomainType]--定义游标 OPEN my_cursor--打开游标 FETCH NEXT FROM my_cursor INTO @TypeId,@Price1,@Original--读取一条 WHILE @@FETCH_STATUS=0--判断状态ahjesus循环 BEGIN--执行某些操作 --PRINT ... 阅读全文