读书人

sql中将数据类型 nvarchar 转换为 num

发布时间: 2013-07-16 22:38:05 作者: rapoo

sql中将数据类型 nvarchar 转换为 numeric 时出错怎么办
select *
from organization o,customer c
where c.customer_square=o.structid

customer_square是nvarchar类型,structid是numeric类型。求大神啊!!在线等! SQL
[解决办法]
select *
from organization o,customer c
where c.customer_square= convert(nvarchar(10),o.structid)

读书人网 >SQL Server

热点推荐