Question

SQL SERVER怎么计算两个字段值的和

我有一张表TAB1，里面有两个decimal类型的字段A和B，A的值是15.80，B的值是12.15，用一条什么查询语句能计算这两个字段的和？

Answer 1

select b.Name as '通道名称', Sum(InSum) as '进', Sum(OutSum) as '出',
cast(Convert(decimal(18, 2),(Sum(InSum)-Sum(OutSum))/cast(Sum(InSum)as float)*10) as char(10)) + '%' as '百分比'
from dbo.FactSitesPerformance a
inner join #temp b on a.SiteKey = b.SiteKey
where CountDate =
(SELECT CONVERT(varchar(10), dateadd(dd, -1, getdate()), 120))
Group by b.SiteKey, b.Name

Answer 2

select (A+B) as 和 from TAB1

Answer 3

select a ,b ,a+b as c from tab1

Answer 4

SQL Server数据中运算符与表达式