我是一个初学者,遇到一个问题,希望大家帮我解决一下。
一个能检测数据同步性的存储过程:CREATE PROCEDURE dbo.up_UpdatePublisherName
(
@pub_id char(4),
@pub_name varchar(40),
@Original_pub_name varchar(40)
)
AS
if exists(select pub_id
from publishers
where (pub_id = @pub_id) AND (pub_name = @Original_pub_name))
Begin
UPDATE publishers SET pub_name = @pub_name
WHERE (pub_id = @pub_id)
End
RETURN
运行后出现以下提示:消息 102,级别 15,状态 1,过程 up_UpdatePublisherName,第 9 行
' ' 附近有语法错误。
消息 102,级别 15,状态 1,过程 up_UpdatePublisherName,第 13 行
' ' 附近有语法错误。怎么回事啊??
一个能检测数据同步性的存储过程:CREATE PROCEDURE dbo.up_UpdatePublisherName
(
@pub_id char(4),
@pub_name varchar(40),
@Original_pub_name varchar(40)
)
AS
if exists(select pub_id
from publishers
where (pub_id = @pub_id) AND (pub_name = @Original_pub_name))
Begin
UPDATE publishers SET pub_name = @pub_name
WHERE (pub_id = @pub_id)
End
RETURN
运行后出现以下提示:消息 102,级别 15,状态 1,过程 up_UpdatePublisherName,第 9 行
' ' 附近有语法错误。
消息 102,级别 15,状态 1,过程 up_UpdatePublisherName,第 13 行
' ' 附近有语法错误。怎么回事啊??
@pub_id char(4),
@pub_name varchar(40),
@Original_pub_name varchar(40)
AS
if exists(select pub_id from publishers where (pub_id = @pub_id) AND (pub_name = @Original_pub_name))
begin
UPDATE publishers SET pub_name = @pub_name WHERE (pub_id = @pub_id)
end
(
@pub_id char(4),
@pub_name varchar(40),
@Original_pub_name varchar(40)
)
AS if exists(select pub_id from publishers
where pub_id = @pub_id AND pub_name = @Original_pub_name)
begin
UPDATE publishers SET pub_name = @pub_name WHERE pub_id = @pub_id
End
RETURN
--有几个空格是全角