set ANSI_NULLS OFF
set QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[z_Clienteligib_update]@creationtimestamp datetime,
@user_id varchar(20),
@survey_id varchar(50),
@facility_id varchar(20),
@eligibility_id varchar(20),
@onfilecount varchar(20),
@submitted varchar(20),
@firstname varchar(50),
@lastname varchar(50),
@aliases varchar(255),
@medrecnum datetime,
@sd_id varchar(20)
ASGO
BEGIN
update survey
set creationtimestamp=@creationtimestamp,user_id=@user_id,survey_id=@survey_id,facility_id=@facility_id,eligibility_id=@eligibility_id,onfilecount=@onfilecount,submitted=@submitted,firstname=@firstname,lastname=@lastname,aliases=@aliases,medrecnum=@medrecnum
where sd_id=@sd_idEND
这个存储过程总是提示消息 137,级别 15,状态 2,第 3 行
必须声明标量变量 "@creationtimestamp"。求救啊
set QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[z_Clienteligib_update]@creationtimestamp datetime,
@user_id varchar(20),
@survey_id varchar(50),
@facility_id varchar(20),
@eligibility_id varchar(20),
@onfilecount varchar(20),
@submitted varchar(20),
@firstname varchar(50),
@lastname varchar(50),
@aliases varchar(255),
@medrecnum datetime,
@sd_id varchar(20)
ASGO
BEGIN
update survey
set creationtimestamp=@creationtimestamp,user_id=@user_id,survey_id=@survey_id,facility_id=@facility_id,eligibility_id=@eligibility_id,onfilecount=@onfilecount,submitted=@submitted,firstname=@firstname,lastname=@lastname,aliases=@aliases,medrecnum=@medrecnum
where sd_id=@sd_idEND
这个存储过程总是提示消息 137,级别 15,状态 2,第 3 行
必须声明标量变量 "@creationtimestamp"。求救啊
@user_id varchar(20),
@survey_id varchar(50),
@facility_id varchar(20),
@eligibility_id varchar(20),
@onfilecount varchar(20),
@submitted varchar(20),
@firstname varchar(50),
@lastname varchar(50),
@aliases varchar(255),
@medrecnum datetime,
@sd_id varchar(20)
AS BEGIN
update survey
set creationtimestamp=@creationtimestamp,user_id=@user_id,survey_id=@survey_id,facility_id=@facility_id,eligibility_id=@eligibility_id,onfil ecount=@onfilecount,submitted=@submitted,firstname=@firstname,lastname=@lastname,aliases=@al iases,medrecnum=@medrecnum
where sd_id=@sd_id ;END