当前位置：网站首页>Sum method for varchar type in SQL (type error)

Sum method for varchar type in SQL (type error)

2022-04-22 08:42:00 【Mechanical bucket running】

When checking the code , The field is found to be misspelled , Replace with the required fields , Type error , Before that, we modified the table structure of the database design . Use this method to avoid changing the database 

select SUM(cast(  Required fields  as numeric(12,0))) from testTable where departmentID='REACH & DEVELOPMENT';

Just change the required field to the type you need to change .

版权声明
本文为[Mechanical bucket running]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220745203261.html

边栏推荐

猜你喜欢

随机推荐