jackfor001的专栏

原创 Sql Server：Cursor的例子

use northwinddeclare @CategoryId int,@CategoryName varchar(50)declare myCursor cursor for select CategoryId,CategoryName from Categoriesopen myCursorfetch next from myCursor into @CategoryId,@Category