在SQL Server 2008中的select语句中处理INT [英] Handling INT in select statement in SQL server 2008
问题描述
亲爱的专家,
如何在sql server 2008中处理 INT
选择IDNO,INT(ARREARS)作为TR_ARREARS来试试
请协助< br $>
谢谢
我尝试了什么:
我已在互联网上查看并查看了我的笔记
Dear expert,
How do you handle INT in sql server 2008
SELECT IDNO, INT(ARREARS) AS COMP_ARREARS FROM TRIAL
Please assist
Thanks
What I have tried:
I have checked on the Internet and reviewed my notes
推荐答案
试试这个
SELECT IDNO, cast(ARREARS as int) AS COMP_ARREARS FROM TRIAL
请参考以下链接:
CAST和CONVERT(Transact-SQL) [ ^ ]
SQL SERVER - 将文本转换为数字(整数) - CAST和CONVERT [< a href =http://blog.sqlauthority.com/2007/07/07/sql-server-convert-text-to-numbers-integer-cast-and-convert/target =_ blanktitle =New窗口> ^ ]
SQL Server:CAST功能 [ ^ ]
refer these links:
CAST and CONVERT (Transact-SQL)[^]
SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT[^]
SQL Server: CAST Function[^]
这篇关于在SQL Server 2008中的select语句中处理INT的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!