存储过程名：包括页面后台代码和触发器和数据库连接类都有了，并且经过测试完全正确。 ChannelSet_MoveUP（上移） CREATE procedure [dbo].[ChannelSet_MoveUP] @ChannelID INT as DECLARE @SortID int DECLARE @TempSortID INT DECLARE @TempID INT BEGIN TRAN SELECT @SortID=SortID from ChannelSet where Channe
CREATE TABLE sort( id INT PRIMARY KEY, name VARCHAR (40) NOT NULL ) go CREATE TABLE product( id INT PRIMARY KEY, sortid INT NOT NULL REFERENCES sort(id) ON DELETE CASCADE, name VARCHAR (50) NOT NULL, price VARCHAR NOT NULL, saleprice VARCHAR NOT NUL
