首页 新闻 搜索 专区 学院

动态sql语句

0
悬赏园豆:30 [已关闭问题]

 

SQL存储过程

CREATE procedure dbo.pro_updatetrade

@t_name nvarchar(20),
@t_parentid int,
@t_depth int,
@t_path nvarchar(20),
@t_count int,
@t_order int,
@t_pointcount int,
@t_id int

as

begin
declare @new_order int --新的排序值
declare @new_sql nvarchar(1000) --拼凑的sql语句
declare @old_order int --更新前的排序值

--获取原来的排序值
select @old_order=t_order from bst_trade where t_id=@t_id
set @new_order=0

if @t_order= @old_order
--不需要修改排序值
update bst_trade set t_name=@t_name,t_parentid=@t_parentid,t_depth=@t_depth,t_path=@t_path,t_count=@t_count,t_pointcount=@t_pointcount where t_id=@t_id

else
--获取修改后的值,并更改排序值小于此值的所以记录
begin
select @new_order =max(t_Order) from (select top @t_order t_Order from bst_trade order by t_order asc ) as t

print @new_sql

exec(@new_sql)
print @new_order
update bst_trade set t_order=t_order + 1 where t_order > @new_order -1 and t_parentid=@t_parentid
update bst_trade set t_name=@t_name,t_parentid=@t_parentid,t_depth=@t_depth,t_path=@t_path,t_count=@t_count,t_order=@new_order,t_pointcount=@t_pointcount where t_id=@t_id
end
end
GO

 

 

主要是这一条语句  ,能执行 ,但执行完得到的@new_order是null
    --这条语句一执行  就变成了  select 0=max(t_order)......
    set @new_sql= 'select '+cast( @new_order as varchar) +' =max(t_Order) from  (select top  '+ cast(@t_order as varchar) +' t_Order from bst_trade order by t_order ) as t; '
请问如何解决?

 

等钩的鱼的主页 等钩的鱼 | 初学一级 | 园豆:10
提问于:2009-08-17 14:23
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册