ALTER PROCEDURE Pr_UpdateNewsKindOrder
(
@NewsKindID int,@MoveFlag varchar(20)
)
AS
DECLARE @UpdateOrder int
SET @UpdateOrder = (SELECT KindOrder FROM NewsKinds WHERE NewsKindID=@NewsKindID)
BEGIN TRAN
IF @MoveFlag = 'up'
BEGIN
DECLARE @OtherID int
SET @OtherID = (SELECT NewsKindID FROM NewsKinds WHERE KindOrder = @UpdateOrder-1)
UPDATE NewsKinds SET KindOrder = @UpdateOrder -1 WHERE NewsKindID = @ NewsKindID
UPDATE NewsKinds SET KindOrder = @UpdateOrder WHERE NewsKindID = @OtherID
END
ELSE
IF @MoveFlag = 'down'
BEGIN
DECLARE @OtherUpdateID int
SET @OtherUpdateID = (SELECT NewsKindID FROM NewsKinds WHERE KindOrder = @UpdateOrder+1)
UPDATE NewsKinds SET KindOrder = @UpdateOrder+1 WHERE NewsKindID = @NewsKindID
UPDATE NewsKinds SET KindOrder = @UpdateOrder WHERE NewsKindID = @OtherUpdateID
END
COMMIT TRAN
确定后提示@需要声明,请问@怎么样声明!
(
@NewsKindID int,@MoveFlag varchar(20)
)
AS
DECLARE @UpdateOrder int
SET @UpdateOrder = (SELECT KindOrder FROM NewsKinds WHERE NewsKindID=@NewsKindID)
BEGIN TRAN
IF @MoveFlag = 'up'
BEGIN
DECLARE @OtherID int
SET @OtherID = (SELECT NewsKindID FROM NewsKinds WHERE KindOrder = @UpdateOrder-1)
UPDATE NewsKinds SET KindOrder = @UpdateOrder -1 WHERE NewsKindID = @ NewsKindID
UPDATE NewsKinds SET KindOrder = @UpdateOrder WHERE NewsKindID = @OtherID
END
ELSE
IF @MoveFlag = 'down'
BEGIN
DECLARE @OtherUpdateID int
SET @OtherUpdateID = (SELECT NewsKindID FROM NewsKinds WHERE KindOrder = @UpdateOrder+1)
UPDATE NewsKinds SET KindOrder = @UpdateOrder+1 WHERE NewsKindID = @NewsKindID
UPDATE NewsKinds SET KindOrder = @UpdateOrder WHERE NewsKindID = @OtherUpdateID
END
COMMIT TRAN
确定后提示@需要声明,请问@怎么样声明!
解决方案 »
- 自动刷新页面部分内容...Ajax 吗 ?
- jquery ajax页面进度条的问题
- 兩個DataList嵌套下的CheckBox,如何用js無刷新實現全選、反選、全不選?
- .NET Framework 2.0 SP2出来了吗,安装sqlserver2008 rc0要求,但找不到下载,急啊
- 验证视图状态 MAC 失败,是怎么回事啊?
- window.showModalDialog 不return false 不执行咋回事
- ============如何合并单元格,并给其赋值.使用Excel9.0.dll操作excel=====
- SmtpClient发送163邮件被识别成垃圾邮件,求解决,急急急
- silverlight中调用submitChanges方法的问题
- CheckBoxList绑定数据库问题 急的!
- 100分求解treeview的问题,在线等
- treeview搜索问题
WHERE NewsKindID = @ NewsKindID
|
有问题-〉@NewsKindID
WHERE NewsKindID = @NewsKindID