sp - if and else - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

sp - if and else

Author

Topic

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2005-03-22 : 06:28:16

I have an if statement in a stored procedure as follows:

if @amount=1 and @value=1
begin
select @pp=1
end

I want to add an else @pp=0

What's the correct syntax?

Kristen
Test

22859 Posts

Posted - 2005-03-22 : 07:05:42

if @amount=1 and @value=1
begin
select @pp=1
end
ELSE
begin
select @pp=0
end

Kristen