摘要：-------------------------------------游标和循环--------------------------------DECLARE CATEGORY_CUR SCROLL CURSOR For SELECT*FROM dbo.Categories FOR UPDATE OF CategoryName OPEN CATEGORY_CUR GOUPDATE Categories SET CategoryName='家电' where CURRENT OF CATEGORY_CUR SELECT*FROM Categories DECLARE @VAR 阅读全文

摘要：use SqlTestcreate table Categories( CategoryID INT IDENTITY(1,1) PRIMARY KEY NOT NULL, CategoryName VARCHAR(100) ) GO create table Products ( ProductID INT IDENTITY(1,1) PRIMARY KEY NOT NULL, ProductName VARCHAR(300) NOT NULL, CategoryID INT NOT NULL,CONSTRAINT FK_PRODUCTS_TOCATEGORIES FOREIGN KEY(C 阅读全文