/*------存储1 根据用户输入该学生编号,检查是否存在,若存在则显示出*/
Create procedure p1
@sno char(10) ,@sname char(10),@ssex char(2),@borndate datetime,@classname varchar(50)
As
Begin
If exists(select * from student2 where sno=@sno)
Select * from student2 where sno=@sno
Else
Begin
insert into student2 (sno,sname,ssex,born