存储过程中如何将bit类型转换为int类型或者bit类型如何和1，0进行比较？？？在线等～

[mndn_nana]

@strOrderType = 1--排序类型，默认1为升序

csdn上有篇帖子说 cast(IsTop as int) 可以

我就if cast(@OrderType as int) = 1--升序类型
set @strOrder = ' order by ['+@strOrderField+'] asc'
else
set @strOrder = ' order by ['+@strOrderField+'] desc'
结果当我给@strOrderType输入1或0时，提示@strOrderType该输入参数不能转换，请大侠门赐教～

或者是将@OrderType直接和1比较 具体怎样比？

[wzy_love_sly]

if @strOrderType = 1
select * from table order by id
else
select * from table order by id desc
---------------------
别写order by里啊

[mndn_nana]

对不起，贴错了
我写得就是下面得

if cast(@OrderType as int) = 1--升序类型
set @strOrder = ' order by ['+@strOrderField+'] asc'
else
set @strOrder = ' order by ['+@strOrderField+'] desc'
执行后就提示那个转换错误

[wzy_love_sly]

order by 1或0是什么意思

[mndn_nana]

@strOrderField时排序字段 如UserID之类
@strOrder 是bit型1或0

是不是默认输入的1为int型而不是bit型？

@strOrderType bit = 1--排序类型，默认1为升序


if cast(@OrderType as int) = 1--升序类型
set @strOrder = ' order by ['+@strOrderField+'] asc'
else
set @strOrder = ' order by ['+@strOrderField+'] desc'

1升序排列 0降序排列