存储过程 怎样使用 if 语句 ( 积分: 20 )

5

567567

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-01-06

• #1

CREATE Procedure [ceshi]
as
declare @cs int
if @cs=1
begin
end
else
begin
end
--提示在关键字end 附近有语法错误
GO

 

3

3868474

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-01-06

• #2

begin , end中间不能是空的, 改成这样还错吗?
declare @cs int
if @cs=1
begin
set @cs = 3
end
else
begin
set @cs = 2
end

 

5

567567

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-01-06

• #3

谢谢！！！！这样就好了!!!!