sql中将数据类型 nvarchar 转换为 numeric 时出错怎么处理
sql中将数据类型 nvarchar 转换为 numeric 时出错怎么办
select *
from organization o,customer c
where c.customer_square=o.structid
customer_square是nvarchar类型,structid是numeric类型。求大神啊!!在线等!
------解决方案--------------------
select *
from organization o,customer c
where c.customer_square= convert(nvarchar(10),o.structid)
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)