关键字'convert'附近的语法不正确。 [英] Incorrect syntax near the keyword 'convert'.
本文介绍了关键字'convert'附近的语法不正确。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
关键字''convert''附近的语法不正确。
Incorrect syntax near the keyword ''convert''.
ALTER Procedure [dbo].[buson_getEMPLOYEEIDNAME_s]
(
@Month INT,
@Year INT
)
As
Begin
Select EmpId,Name,(BUSON_SALARYSTR.BASICSALARY / dbo.GetNoofDaysPerMonth(@Month, @Year)) *
(dbo.GetNoofDaysPerMonth(@Month, @Year) - dbo.NoofdaysAbsent(EmpId,@Month,@Year))(convert(decimal, '12343.5787') as BASICSALARY ,BUSON_SALARYSTR.CODE FROM BUSON_EMP
INNER JOIN BUSON_SALARYSTR ON BUSON_SALARYSTR.CODE = BUSON_EMP.SalaryStructure
End
推荐答案
那里不应该有逗号吗?
Shouldn''t there be a comma in there?
Select EmpId,Name,(BUSON_SALARYSTR.BASICSALARY / dbo.GetNoofDaysPerMonth(@Month, @Year)) *
(dbo.GetNoofDaysPerMonth(@Month, @Year) - dbo.NoofdaysAbsent(EmpId,@Month,@Year))(convert(decimal, '12343.5787') as BASICSALARY ,BUSON_SALARYSTR.CODE FROM BUSON_EMP
INNER JOIN BUSON_SALARYSTR ON BUSON_SALARYSTR.CODE = BUSON_EMP.SalaryStructure
Select EmpId,Name,(...) * (...)(convert(decimal, '12343.5787') as ...
-------------------------------^
试试这个:
Try this:
CONVERT(DECIMAL(18,2),'123456.789')
这篇关于关键字'convert'附近的语法不正确。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文