ALTER PROCEDURE dbo.link_join_wordbook
@word varchar(MAX),
@word_id bigint
AS
select @word_id=id from wordbook where word = @word SELECT dbo.link.order_count, dbo.enterprise.en_name,
dbo.enterprise.en_address, dbo.enterprise.area,
dbo.enterprise.id, dbo.enterprise.tf,
dbo.enterprise.past_date, dbo.enterprise.telephone,
dbo.enterprise.phone_web, dbo.link.en_id
FROM dbo.link INNER JOIN
dbo.enterprise ON dbo.link.en_id = dbo.enterprise.id
where dbo.link.en_id = @word_idRETURN
过程或函数 'link_join_wordbook' 需要参数 '@word_id',但未提供该参数。
@word varchar(MAX),
@word_id bigint
AS
select @word_id=id from wordbook where word = @word SELECT dbo.link.order_count, dbo.enterprise.en_name,
dbo.enterprise.en_address, dbo.enterprise.area,
dbo.enterprise.id, dbo.enterprise.tf,
dbo.enterprise.past_date, dbo.enterprise.telephone,
dbo.enterprise.phone_web, dbo.link.en_id
FROM dbo.link INNER JOIN
dbo.enterprise ON dbo.link.en_id = dbo.enterprise.id
where dbo.link.en_id = @word_idRETURN
过程或函数 'link_join_wordbook' 需要参数 '@word_id',但未提供该参数。
--另,你的存储过程要干什么?看不出你的意图啊. 建议看联机帮助 create proc
@word varchar(MAX), ---max 改为数字如 20
@word_id bigint
AS
select @word_id=id from wordbook where word = @wordSELECT dbo.link.order_count, dbo.enterprise.en_name,
dbo.enterprise.en_address, dbo.enterprise.area,
dbo.enterprise.id, dbo.enterprise.tf,
dbo.enterprise.past_date, dbo.enterprise.telephone,
dbo.enterprise.phone_web, dbo.link.en_id
FROM dbo.link INNER JOIN
dbo.enterprise ON dbo.link.en_id = dbo.enterprise.id
where dbo.link.en_id = @word_idRETURNexec link_join_wordbook 时须传入两个参数