[原创]存储过程，insert,case when then,处理性别问题 Virus

ALTER PROCEDURE dbo.StoredProcedure1
 /*
 (
 @parameter1 int = 5,
 @parameter2 datatype OUTPUT
 )
 */
 /*@stuNum nchar(10),*/
 @stuNum nchar(10),
 @stuName nchar(10),
 @stuPassWord nchar(10),
 @stuSex char(10),
 @stuClassNum nchar(10),
 @name nchar(10) output
 
 with encryption
 
AS
 SET NOCOUNT off
 
 insert into student values(newid(),@stuNum,@stuName,@stuPassWord,
 case @stuSex
 when '男' then 'true'
 when '女' then 'false'
 end
 ,@stuClassNum)
 
 select stuNum,stuName from student where stuName=@stuName
 
 select @name=stuName from student
 
 RETURN @name