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"。求救啊

解决方案 »

  1.   

    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) 
    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 
      

  2.   

    不行啊 加括号也没用 AS后面本来就有GO