摘要: SELECT * FROM [goods] DECLARE test_cursor CURSOR scroll FOR SELECT goods_no, [unitprice] FROM [goods] OPEN test_cursor DECLARE @goodsno INT DECLARE @num numeric(10, 2) FETCH next FROM test_cursor INTO @goodsno, @num WHILE @@FETCH_STATUS = 0 begin PRINT @goodsno ... 阅读全文
posted @ 2014-02-09 15:32 Rain520 阅读(298) 评论(0) 推荐(0) 编辑