我现在 在使用sql的报表服务,但是在使用COUNT()时,因为我的数据表字段类型为(nvarcha) [ ( 50 ) ],我要在查询语句中将其转化为int,该怎么写?????假如我的字段为ap,we,tr,qw
解决方案 »
- 各位帮我看看这个触发器写的对吗?
- 给个ms sql 项目管理系统的代码
- SQLServer2000自动增量列如果超出最大范围怎样处理?
- 存储过程中怎么扑获错误信息
- delete的速度和锁表,看似简单的一个问题却搞不定,大家帮忙看看
- 请问:SQL Server的登录帐户(如 sa )密码在哪里修改?
- 如何得到数据库逻辑文件名及存存储过程执行时间
- sql server 2000提示安装程序创建了一个挂起操作,需重启计算机,可重启不管用~~~急!
- 重装系统后SQL SERVER2000无法装载与语言相关的资源
- 第一次到这里来提问,关于数据库恢复的问题,谢谢!竹斑竹呢?
- 一条sql语句实现一个简单的功能
- 请Sql高手,帮忙解决下列难题!
cast(ap as int)
CONVERT(int, isnull(SH_BN,'0')) AS SH_BN,
CONVERT(int, isnull(SH_BN2,'0')) AS SH_BN2,
CONVERT(int, isnull(SH_BP, '0')) AS SH_BP,
CONVERT(int, isnull(SH_EPI,'0')) AS SH_EPI,
CONVERT(int, isnull(SH_AM2,'0')) AS SH_AM2,
CONVERT(int, isnull(SH_NW,'0')) AS SH_NW,
CONVERT(int, isnull(SH_PW, '0')) AS SH_PW,
CONVERT(int, isnull(SH_DN,'0')) AS SH_DN,
CONVERT(int, isnull(SH_LPW, '0')) AS SH_LPW,
CONVERT(int, isnull(SH_OD,'0')) AS SH_OD,
CONVERT(int, isnull(SH_NWI, '0')) AS SH_NWI,
CONVERT(int, isnull(SH_GATE,'0')) AS SH_GATE,
CONVERT(int, isnull(SH_RES,'0')) AS SH_RES,
CONVERT(int, isnull(SH_GOX,'0')) AS SH_GOX,
CONVERT(int, isnull(SH_PS, '0')) AS SH_PS,
CONVERT(int, isnull(SH_DP, '0')) AS SH_DP,
CONVERT(int, isnull(SH_AP,'0')) AS SH_AP,
CONVERT(int, isnull(SH_HB,'0')) AS SH_HB,
CONVERT(int, isnull(SH_SPH, '0')) AS SH_SPH,
CONVERT(int, isnull(SH_SNL,'0')) AS SH_SNL,
CONVERT(int, isnull(SH_SPL, '0')) AS SH_SPL,
CONVERT(int, isnull(SH_SN, '0')) AS SH_SN,
CONVERT(int, isnull(SH_QI, '0')) AS SH_QI,
CONVERT(int, isnull(SH_DI, '0')) AS SH_DI,
CONVERT(int, isnull(SH_SP2,'0')) AS SH_SP2,
CONVERT(int, isnull(SH_CO, '0')) AS SH_CO,
CONVERT(int, isnull(SH_IN, '0')) AS SH_IN,
CONVERT(int, isnull(SH_PUSE,'0')) AS SH_PUSE,
CONVERT(int, isnull(SH_CB, '0')) AS SH_CB,
CONVERT(int, isnull(SH_NUL, '0')) AS SH_NUL
FROM xxx
convert (int,qw)