***写存储过程能用一些if..else的判断吗？***

[xuege]

我想这样：
CREATE PROCEDURE zzz(@courseNo char(15))
AS
if @courseNo is null then
begin
select *
from course
end
else
begin
select *
from course
where course.courseNo=@courseNo
end
GO
“检查语法”总说在then和else有错误，是怎么回事？谢谢指点！！！

[wgy2008]

CREATE PROCEDURE zzz(@courseNo char(15))
AS
if @courseNo is null
begin
select *
from course
end
else
begin
select *
from course
where course.courseNo=@courseNo
end
GO

[joygxd]

CREATE PROCEDURE zzz(@courseNo char(15))
AS
if @courseNo is null
begin
select *
from course
end
else
begin
select *
from course
where course.courseNo=@courseNo
end
GO

[wandering_guy]

把then去掉试试

[black_snail]

缺少END

[psxfghost]

给你一个帮助里的例子:
IF (@ErrorSaveVariable <> 0)
BEGIN
PRINT 'Errors encountered, rolling back.'
PRINT 'Last error encountered: ' +
CAST(@ErrorSaveVariable AS VARCHAR(10))
ROLLBACK
END
ELSE
BEGIN
PRINT 'No Errors encountered, committing.'
COMMIT
END
RETURN @ErrorSaveVariable

^_^

[mjhnet]

不需要then，去掉即可


CREATE PROCEDURE zzz(@courseNo char(15))
AS
if @courseNo is null
begin
select *
from course
end
else
begin
select *
from course
where course.courseNo=@courseNo
end

[happydreamer]

CREATE PROCEDURE zzz(@courseNo char(15))
AS

IF @courseNo is null
BEGING
SELECT * FROM course
END
ELSE
BEGIN
SELECT * FROM course WHREE courseNo=@courseNo
END

GO

[wuqiuzhi]

在sql server里面，判断使用的if。。。else
不是if。。。then。。。。else
故上面应该去掉then

[firetoucher]

up
不要then
CREATE PROCEDURE zzz(@courseNo char(15))
AS
if @courseNo is null
begin
select *
from course
end
else
begin
select *
from course
where course.courseNo=@courseNo
end
GO

[crycat]

好像是基本的语法题呢
怎么这么多人回答