学习带参数的存储过程
创建表person
create table person(name varchar(10),age int)
insert into person values ('张三',10)
insert into person values ('李四',20)
创建存储过程 shifou_chengren ,判断张三、李四是否成年人
create procedure shifou_chengren
@name varchar(10)
as
if EXISTS(select * from person where name=@name and age<18)
print rtrim(@name)+'是未成年人';
else
print rtrim(@name)+'不是未成年人';
go
----------------------------------------
执行存储过程
exec shifou_chengren '张三'
exec shifou_chengren '李四'