create proc usp_return
@i int
as
if( @i >= 0)
begin
print 'bigger to 0'
return (0)
end
else
begin
print 'smaller to 0'
return (1)
end
@i int
as
if( @i >= 0)
begin
print 'bigger to 0'
return (0)
end
else
begin
print 'smaller to 0'
return (1)
end
@i int
as
if( @i >= 0)
select 'bigger to 0'
else
select 'smaller to 0'