这样的语句如何传递参数？急

2006-03-11 08:57:10 135 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Android13 SurfaceFlinger启动流程分析在Android13版本中，SurfaceFlinger是由Android.bp去启动init.rc文件，然后再解析文件去加载SurfaceFlinger。上面方法主要处理如下：1、调用surfaceflinger的createSurfaceFlinger方法，实例化surfaceflinger。2、调用flinger(surfaceflinger)的init()方法，在客户端连接之前进行初始化。阅读详情

declare @sql varchar(4000) ;
set @sql ='select rhbh as ''人员考号'',b.name as ''姓名'', ''性别'' = case xb when 1 then ''男'' when 0 then ''女'' end , d.name as ''县区'', c.name as ''矿'',dbo.f_join_str_sumdf(rhbh) as ''总分'''
select @sql =@sql +',sum(case f.flmc when '''+flmc+''' then df end) ['+flmc+']'
from (select distinct flmc from SS_KSFL) as a select @sql =@sql +'from yw_ks as a ,SS_USER as b ,SS_Mine as c , SS_XQ as d ,YW_KTLR as e , SS_KSFL as f , SS_FLMX as g where a.rhbh = b.id and b.ssk = c.id and b.xq = d.id and a.wtdm = e.wtdm and f.fldm = e.fldm and g.fldm = f.fldm and b.xq =''@XQ'' and b.ssk =''@SSK''
and a.KSSJ between ''@START'' and ''@END'' group by rhbh,b.name,b.xb,d.name,c.name' exec(@sql)

说明：b.xq 和 b.ssk 都是int 型的
a.KSSJ 是DateTime 类型的

在不传递参数@XQ、@SSK、@START、@END时，该语句没问题，当加上语句and b.xq =''@XQ'' and b.ssk =''@SSK'' and a.KSSJ between ''@START'' and ''@END''就报错
"将 varchar 值 '@XQ' 转换为数据类型为 int 的列时发生语法错误。"

问下，这样的语句如何传递参数？

...全文