Question

SQL存储过程语法错误，

CREATE PROCEDURE Pro_saveST_zz

AS

update zz
begin
if
kmfl = '负债类'
then
jcye='jf-df'
else
jcye='df-jf'

end;

GO
总是报错语法错误，请帮帮忙

Answer 1

CREATE PROCEDURE Pro_saveST_zz

AS

begin
update zz case when
kmfl = '负债类'
then
jcye='jf-df'
else
jcye='df-jf'

end;

追问

报CASE附近有语法错误

追答

CREATE PROCEDURE Pro_saveST_zz

AS

begin
update zz case when
kmfl = '负债类'
then
set jcye='jf-df'
else
set jcye='df-jf'

追问

还是报CASE附近有语法错误

Answer 2

CREATE PROCEDURE Pro_saveST_zz

AS

begin
update zz
set jcye=(case when kmfl = '负债类' then'jf-df'
else'df-jf' end)

end

Answer 3

begin
if....endif
end