3.3w+
社区成员
大家帮忙看看这个存储过程错在哪里？谢谢
大家帮忙看看这个存储过程错在哪里？谢谢
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
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
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
csshan 2008-03-03
@Amag不存在你的定义变量声明了
改成@Amsg就好了
改成@Amsg就好了
flairsky 2008-03-03
这个……
变量名……仔细仔细
变量名……仔细仔细
kk19840210 2008-03-03
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
@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
qiuming0306 2008-03-03
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
jxwangjm 2008-03-03
@Amag变量名错了，改成@Amsg就好了
tongtianxiao 2008-03-03
如果记录淬在 如何取得返回值？在sql查询分析器里显示出id
pt1314917 2008-03-03
调用存储过程不需要括号吧？
tongtianxiao 2008-03-03
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吨赣榆' 附近有语法错误。
