在qt中执行自己的sql函数

Question

我的sql函数应该返回int

CREATE FUNCTION returnPriceOnPlace(@SpectacleName varchar(50), @Row int, @Place int, @Date smalldatetime)
RETURNS int 
AS
BEGIN
DECLARE @Price int
SELECT @Price = dbo.Ticket.Price FROM  dbo.Spectacle INNER JOIN
      dbo.Poster ON dbo.Spectacle.Id_Spectacle = dbo.Poster.Id_Spectacle INNER JOIN
      dbo.Ticket ON dbo.Poster.Id_Poster = dbo.Ticket.Id_Poster INNER JOIN
      dbo.Place ON dbo.Ticket.Id_Place = dbo.Place.Id_Place
WHERE Spectacle.name = @SpectacleName AND Place.row = @Row AND Place.place = @Place AND Poster.Date = @Date
RETURN @Price
END 

像这样在sql中测试这个函数，它工作得很好

Select dbo.returnPriceOnPlace('Hamlet',5,10,'20190124 22:00:00')

但是如何在Qt中执行这个函数呢？我用这种方法试了试，但不起作用

qry->prepare("SELECT returnPriceOnPlace(?,?,?,?");
qry->addBindValue(name);
qry->addBindValue(tempRow);
qry->addBindValue(tempPlace);
qry->addBindValue(dateTime);

Answer 1

重点是我没有在这里结束qry->prepare("SELECT returnPriceOnPlace(?，？“))中的括号；