摘要:
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 ... 阅读全文