1.sql

数据库的开发事例

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