大家帮忙看看这个存储过程错在哪里？谢谢

[tongtianxiao]

大家帮忙看看这个存储过程错在哪里？谢谢

create PROCEDURE instText(
@Amsg varchar(500),
@Atel varchar(200),
@Acode varchar(30),
@Asource smallint,
@ID bigint OUTPUT /* 如果存在返回ID=1，否则插入 */
)
as
if exists(select id from msg where msg=@Amag and tel=@Atel and code=@Acode and source=@Asource)
set @ID=1
else
INSERT INTO msg (msg,tel,code,source) VALUES (@Amsg,@Atel,@Acode,@Asource)
go

[tongtianxiao]

create PROCEDURE instText(
@Amsg varchar(500),
@Atel varchar(200),
@Acode varchar(30),
@Asource smallint,
@ID bigint OUTPUT /* 如果存在返回ID=1，否则插入 */
)
as
if exists(select id from msg where msg=@Amsg and tel=@Atel and code=@Acode and source=@Asource)
set @ID=1
else
INSERT INTO msg (msg,tel,code,source) VALUES (@Amsg,@Atel,@Acode,@Asource)
go



我调用 exec dbo.insttext('编号5027显电7613211 7998590 烟台30到100吨赣榆','7613211 7998590','潍坊',537,1)
怎么报错：
第 1 行: '编号5027显电7613211 7998590 烟台30到100吨赣榆' 附近有语法错误。

[pt1314917]

调用存储过程不需要括号吧？

[tongtianxiao]

如果记录淬在 如何取得返回值？在sql查询分析器里显示出id

[jxwangjm]

@Amag变量名错了，改成@Amsg就好了

[qiuming0306]

create PROCEDURE instText(    
  @Amsg varchar(500), 
  @Atel varchar(200), 
  @Acode varchar(30), 
  @Asource smallint, 
  @ID  bigint   OUTPUT /*   如果存在返回ID=1，否则插入   */      
  )    
  as    
  if  exists(select id from msg  where msg=@Amsg and tel=@Atel and code=@Acode and source=@Asource)    
  set  @ID=1    
  else    
  INSERT INTO msg (msg,tel,code,source) VALUES (@Amsg,@Atel,@Acode,@Asource) 
  go

[kk19840210]

create PROCEDURE instText(
@Amsg varchar(500),
@Atel varchar(200),
@Acode varchar(30),
@Asource smallint,
@ID bigint OUTPUT /* 如果存在返回ID=1，否则插入 */
)
as
if exists(select id from msg where msg=@Amag and tel=@Atel and code=@Acode and source=@Asource)
set @ID=1
else
INSERT INTO msg (msg,tel,code,source) VALUES (@Amsg,@Atel,@Acode,@Asource)
go

[flairsky]

这个……

变量名……仔细仔细

[csshan]

@Amag不存在你的定义变量声明了
改成@Amsg就好了