1.sql

来自「数据库的开发事例」· SQL 代码 · 共 14 行

create  procedure   sel_price(@x money =null,@y money =null)
as
if (@x is null or @y is null)
begin
print '必须提供两个价格作为参数'
return  13
end
if not exists(select * from 	产品 where 单价  between @x  and @y)
begin
	print  '没有满足条件的记录'
 	return  -103
end
select * from 	产品 where 单价  between @x  and @y
return 0