更正此语法错误

本文介绍了更正此语法错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

从dbo.tbl_Emp中选择Eid，EName，ESalary 从dbo.tbl_Emp选择Eid，EName，ESalary作为BS， （ESalary + ESalary * 0.15 + ESalary * 0.235）作为GS 来自dbo.tbl_Emp - -GS = BS + 15％BS（HRA）+ 23.5BS（DA） 消息102，级别15，状态1，第4行 '+'附近的语法不正确。 我尝试了什么： 我试过执行上面的查询

解决方案

试试：

SELECT Eid，EName，ESalary AS BS，（ESalary + ESalary * 0.15 + ESalary * 0. 235 ） AS GS FROM dbo.tbl_Emp

SELECT Eid，EName，ESalary As BS，（ESalary +（ESalary） * 0.15）+（ESalary * 0.235））作为GS 来自 dbo.tb l_Emp

select Eid, EName, ESalary from dbo.tbl_Emp select Eid, EName, ESalary from dbo.tbl_Emp as BS, (ESalary+ESalary*0.15+ESalary*0.235) as GS from dbo.tbl_Emp --GS=BS+15%BS(HRA)+23.5BS(DA) Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '+'. What I have tried: I tried executing the above query

解决方案

Try:

SELECT Eid, EName, ESalary AS BS, (ESalary+ESalary*0.15+ESalary*0.235) AS GS FROM dbo.tbl_Emp

SELECT Eid, EName, ESalary As BS, (ESalary + (ESalary * 0.15) + (ESalary * 0.235)) as GS FROM dbo.tbl_Emp