请问这几句SQL语句CAST哪里出了问题,谢谢
declare @pageSum int
set @pageSum = 3;
exec ('SELECt TOP 2 * FROM userInfo T WHERe T.uId NOT IN (SELECt TOP '+CAST(@pageSum AS varchar(30))+' uID FROM userInfo ORDER BY uid desc) order by uid desc')
SQL语句的CAST哪里有问题
答案:2 悬赏:70
解决时间 2021-02-02 19:44
- 提问者网友:傀儡离开
- 2021-02-02 03:54
最佳答案
- 二级知识专家网友:情窦初殇
- 2021-02-02 04:28
declare @pageSum int
declare @ss varchar(1000)
set @pageSum = 3;
set @ss='SELECt TOP 2 * FROM userInfo T WHERe T.uId NOT IN (SELECt TOP '+CAST(@pageSum AS varchar(30))+' uID FROM userInfo ORDER BY uid desc) order by uid desc'
exec (@ss)
declare @ss varchar(1000)
set @pageSum = 3;
set @ss='SELECt TOP 2 * FROM userInfo T WHERe T.uId NOT IN (SELECt TOP '+CAST(@pageSum AS varchar(30))+' uID FROM userInfo ORDER BY uid desc) order by uid desc'
exec (@ss)
全部回答
- 1楼网友:万千宠爱
- 2021-02-02 05:02
你可以参考一下我以前回答过的问题:http://wenwen.sogou.com/z/q756269260.htm
cast是将一种数据类型的表达式转换为另一种数据类型的表达式。
语法
cast (expression as data_type [ (length ) ] )
功能分解步骤
1. cast(id as varchar(20)) 将 id转换为类型 varchar(20),若 cast(2011 as varchar(20))转换结果为 '2011'
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯