服务器: 消息 137，级别 11，状态 1，行 0 必须声明变量'

来源：百度知道 编辑：UC知道 时间：2024/05/24 03:46:43
declare @i int
set @i=1
EXECUTE sp_makewebtask @outputfile = N'D:\53 backup\问题解决办法\sql流程查询\outputhtml.html',
@query = N'select [paymentcode],[applydate],[remark] from [workflowqueryzkj] where [wfq_id]=@i
select projectcode,procedurename,fromtaskname,fromdate,totaskname,signdate,finishdate from WorkFlowAct wa where ((wa.CaseCode=104361) or (wa.applicationcode=624 and procedurecode<>100156)) and (projectcode is not null) order by casecode,fromdate',
--@templatefile = N'D:\53 backup\问题解决办法\sql流程查询\outputhtml2.tpl',
@fixedfont=1,
@HTMLheader=3,
@webpagetitle=N'流程查询结果页面',
@resultstitle=N'查询结果',
@dbname=N'tangchenpm',
@whentype=1,
@procname=N'tangchenpm Web 页 2',
@codepage=65001,

字符串里有变量
这样用
declare @i int,@query nvarchar(4000)
set @i=1
SET @query= N'select [paymentcode],[applydate],[remark] from [workflowqueryzkj] where [wfq_id]='+RTRIM(@i)+'
select projectcode,procedurename,fromtaskname,fromdate,totaskname,signdate,finishdate from WorkFlowAct wa where ((wa.CaseCode=104361) or (wa.applicationcode=624 and procedurecode<>100156)) and (projectcode is not null) order by casecode,fromdate'
EXECUTE sp_makewebtask @outputfile = N'D:\53 backup\问题解决办法\sql流程查询\outputhtml.html',

@query =@query,
--@templatefile = N'D:\53 backup\问题解决办法\sql流程查询\outputhtml2.tpl',
@fixedfont=1,
@HTMLheader=3,
@webpagetitle=N'流程查询结果页面',
@resultstitle=N'查询结果',
@dbname=N'tangchenpm',
@whentype=1,