sql - 如何解决 SQL Server 错误 "An expression of non-boolean type specified in a context where a condition is expected, near ' GROUP'"

Question

这是我的查询

INSERT INTO Tbl_DomainWiseStats (subdomainid, tendercount, Type_cat, DisplayText)
    SELECT 
        ' + CAST(@domain_id AS VARCHAR(100)) + '
        , TenderCount
        , ''ByCountry''
        ,Country 
    FROM 
        (SELECT DISTINCT 
             V.Country, 
             COUNT(DISTINCT Sr_No) as TenderCount 
         FROM 
             dbo.viewgetlivetenders V 
         WHERE 
             '+  @Domainquery +' 
         GROUP BY 
             V.Country) a 
ORDER BY  
    TenderCount 

错误信息:

[SQLSTATE 42000] (Error 4145) An expression of non-boolean type specified in a context where a condition is expected, near 'GROUP'

Answer 1

你需要完成你的 where 子句..

这会导致错误:

select * from test where id

但不是这个:

select * from test where id =1

在您的动态 SQL 中，以下部分导致问题..

WHERE '+  @Domainquery +' 
                        GROUP BY V.Country