更正此语法错误 [英] Correct this syntax error

问题描述

从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

这篇关于更正此语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！