添加学员存储过程

最新推荐文章于 2022-07-22 11:14:42 发布

aifan2109

最新推荐文章于 2022-07-22 11:14:42 发布

阅读量157

点赞数

原文链接：http://www.cnblogs.com/Spinoza/p/10246281.html

版权

use StudentManager
go
if exists(select * from sysobjects where name='usp_AddStudent')
    drop procedure usp_AddStudent
go
create procedure usp_AddStudent
@studentName varchar(20),
@Gender char(2),
@Birthday smalldatetime,
@StudentIdNo numeric(18,0),
@PhoneNumber varchar(50),
@StudentAddress varchar(500),
@ClassId int
as
    insert into Students(studentName,Gender,Birthday,StudentIdNo,PhoneNumber,StudentAddress,ClassId)
            values(@studentName,@Gender,@Birthday,@StudentIdNo,@PhoneNumber,@StudentAddress,@ClassId) 
go

--测试存储过程
exec usp_AddStudent '小赵','男','1988-09-09',120226198808091217,'','',2

select * from Students