数据库操作--获取存储过程的返回值

用SQL Server数据库写了个存储进程，代码以下

<span>create procedure proc_select 
@id int
as
begin
if exists(select * from news where id=@id)
	return 1
else
	return 2
end
</span><span>create procedure