Question

sql语句 where 后的条件语句 冒号后的变参是如何定义的，在SQL2005中怎么总是报错呢？

sql语句 where 后的条件语句 冒号后的变参是如何定义的，在SQL2005中怎么总是报错呢？

a.dwbh=b.dwbh
and a.rq>=:srq
and a.rq<=:erq
源代码如下：

select b.danwbh,b.dwmch,
sum(a.hsje) as hsje,sum(a.ml) as ml,round(sum(a.ml)/sum(a.hsje)*100,2) as mll
from pf_ckhz a,mchk b
where a.dwbh=b.dwbh
and a.rq>=:srq
and a.rq<=:erq
and b.dwmch like :dw_bh
and a.djbh like 'XS%'
and a.djbh not like 'XSD%'
group by b.danwbh,b.dwmch
having sum(a.hsje)<>0
order by b.danwbh

Answer 1

SQL 通过declare 方式定义参数的，例如declare @srq int
你的sql 语句都不符合sql 语法 变参需要单独定义 并附值