创建存储过程

表如下：

create table T_Resume

(

Id bigint primary key,

Name nvarchar(32) not null,

Gender int not null,

Image nvarchar(max) not null,

Birdate datetime not null,

Edudeg nchar(10) not null,

Tel char(11) not null,

QQ varchar(11) not null,

Email nvarchar(64) not null,

NativePlace nvarchar(128) not null,

Hobby nvarchar(max),

Others nvarchar(max)

)

存储过程如下：

1.取数据

create PROCEDURESelectResume

AS
begin
SELECT Id,Name,
case gender when 0 then '男' when 1 then '女' end as sex ,
Image,Birdate,Edudeg,Tel,QQ,Email,NativePlace,Hobby,Others
FROM T_resume

end

go

2.插入数据

ALTER PROCEDURE [dbo].[InsertResume]
@Name nvarchar(32),
@Gender int,
@Image nvarchar(max),
@Birdate datetime,
@Edudeg nchar(10),
@Tel char(11),
@QQ varchar(11),
@Email nvarchar(64),
@NativePlace nvarchar(128),
@Hobby nvarchar(max),
@Others nvarchar(max)
AS
BEGIN
insert into T_resume values
(@Name,@Gender,@Image,@Birdate,@Edudeg,@Tel,@QQ,@Email,@NativePlace,@Hobby,@Others)
END

3.修改数据（根据输入的Id修改）

ALTER PROCEDURE [dbo].[UpdateResume]
@Id int,
@Name nvarchar(32),
@Gender int,
@Image nvarchar(max),
@Birdate datetime,
@Edudeg nchar(10),
@Tel char(11),
@QQ varchar(11),
@Email nvarchar(64),
@NativePlace nvarchar(128),
@Hobby nvarchar(max),
@Others nvarchar(max)
AS
BEGIN
update T_resume set Name=@Name,Gender=@Gender,Image=@Image,
Birdate=@Birdate,Edudeg=@Edudeg,Tel=@Tel,QQ=@QQ,Email=@Email,
NativePlace=@NativePlace,Hobby=@Hobby,Others=@Others
where Id=@Id
END

4.删除数据（根据输入的Id删除）

ALTER PROCEDURE [dbo].[DeleteResume]
@Id int
AS
BEGIN
delete from T_resume where Id=@Id
END