问题描述
我也有一个在SQL Server中也可以使用的查询，但是当我将其保存在delphi的ado查询中时，它不起作用，并因以下错误而停止：
I have a Query that works in SQL Server as well but when i save it in ado query in delphi it doesn't work and stops with this error :
Incorrect syntax near 'GO'
但以下代码正确而且没有任何错误。我在sql server中测试过。
下面的代码不是常规代码，因为我从delphi复制并粘贴了它。
But the below code is correct and has not any error . i was tested it in sql server .The below code is not Regular because i copy and past it from delphi .
我的查询：
create function GetTedad(@pfcode INT, @pdcode INT) returns int
as begin declare @Tedad int;
select @Tedad= sum(t2.tedade_avalie) from Tbl_avalie_salon t2 where t2.FCode = @pfcode and t2.DCode = @pdcode
return (@Tedad); end;
GO
create function getSumBSen2(@pfcode INT, @pdcode INT, @pSen INT) returns int
as begin declare @r int;
select @r= sum(t2.t_shab + t2.t_rooz) from tbl_talafat_dan t2 where t2.FCode = @pfcode and t2.DCode = @pdcode and t2.sen <= @pSen;
return (@r); end;
GO
select t1.sen, sum(t1.d_rooz) as d1, sum(t1.d_shab) as d2, sum(t1.d_rooz + t1.d_shab) as d_sum,
Round((sum((1000*(t1.d_rooz+t1.d_shab)+0.01)/((dbo.GetTedad(81, 1))-(dbo.getSumBSen2(81, 1, t1.sen))))),1) as Saraneh
from tbl_talafat_dan t1 where t1.FCode =81 and t1.DCode = 1 group by t1.sen;
推荐答案
关键字不是SQL Server语句
The GO keyword is not a SQL Server statement
您必须从Delphi代码中删除此语句才能执行Sql语句。查看此问题的示例
You must remove this statement from your Delphi Code in order to execute your Sql sentence. check this question for an example How to run a database script file from Delphi?
这篇关于Delphi与SQL Server之间的冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！