SQL SERVER 2005存储过程

create table Person(
id int identity(1,1) primary key,
name varchar(50) not null
);


create table users(
id int identity(1,1) primary key,
name varchar(50) not null,
age int not null,
sex char(2) not null,
address varchar(100) not null
);


insert into users values('admin',20,'男','嘉禾石桥');
insert into users values('administror',21,'男','湖南郴州');
insert into users values('ad',22,'男','郴州嘉禾');


create proc proc_1
  as
 select * from users;


exec proc_1


create proc proc_2
 as 
 insert into users values('ad',21,'男','嘉禾石桥');
 select * from users;
go


exec proc_2;


drop proc proc_2;


create proc proc_2
 @name varchar(50)
 as 
 select * from users where name=@name;
go


exec proc_2 'admin';
 
create proc proc_3
 @name varchar(50),
 @age int
 as 
 select * from users where name=@name and age=@age;
go


exec proc_3 'admin',20;


create proc proc_4
 @name varchar(50),
 @age int output
 as
 select @age=age from users where name=@name;
 go


declare @age int
exec proc_4 'admin',@age output;


create proc proc_5
 @name varchar(50)
 as
 declare @age int;
 exec proc_4 @name,@age output;
 insert into person values(@age);
go


exec proc_5 'admin';