Vb.net中的sql查询中的语法附近不正确 [英] Incorrect Syntax near) in sql query in Vb.net
本文介绍了Vb.net中的sql查询中的语法附近不正确的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的所有人,
我正在尝试在vb.net中的sql查询中加入nvarchar列。但它显示不正确的语法)。这是我的查询 -
SqlCmd =新的SqlCommand(SELECT SUM(CAST(BasicSal AS double))AS BasicSalary FROM vwGetEmpCntrctWisePaymnt,ConnString)
我的BasicSal是nvarchar列在SQL Server2000中。
任何帮助都将受到高度赞赏。
解决方案
double不是有效的SQL数据类型:你的意思是 FLOAT?
SqlCmd =新的SqlCommand( SELECT SUM(CAST(BasicSal AS FLOAT))AS BasicSalary FROM vwGetEmpCntrctWisePaymnt,ConnString)
DOUBLE是别名,并且它们不允许进入CAST函数。
试试这个:
SELECT SUM(CAST(BasicSal AS decimal))AS BasicSalary FROM vwGetEmpCntrctWisePaymnt
Dear All,
I am trying To sum of nvarchar column in sql query in vb.net. But its showing incorrect syntax near ). Here is my query -
SqlCmd = New SqlCommand("SELECT SUM(CAST(BasicSal AS double)) AS BasicSalary FROM vwGetEmpCntrctWisePaymnt",ConnString)
My BasicSal is nvarchar column in SQL Server2000.
Any help will be highly appreciated.
解决方案
"double" is not a valid SQL datatype: did you mean "FLOAT"?
SqlCmd = New SqlCommand("SELECT SUM(CAST(BasicSal AS FLOAT)) AS BasicSalary FROM vwGetEmpCntrctWisePaymnt",ConnString)
DOUBLE is an alias, and they aren't allowed in CAST functions.
Try this:
SELECT SUM(CAST(BasicSal AS decimal)) AS BasicSalary FROM vwGetEmpCntrctWisePaymnt
这篇关于Vb.net中的sql查询中的语法附近不正确的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文