@sex varchar(50) = '',
@name varchar(100) = ''
@I_ReturnMessage varchar(100)
AS
BEGIN
if(@Sex = '男' or @Sex = '女')
begin
select s.StudentID as 学生ID,s.StudentName as 学生姓名,s.Sex as 性别,su.UserDescription as 创建者
from
Student s
left join
SysUser su
on s.CreateUserID = su.UserId
where s.Sex = @Sex or s.StudentName like '%' + @Name + '%'
return 0
end
else
begin
set @I_ReturnMessage = 'Message:性别信息错误'
return -1
end
END
求大神帮忙解答下 我的这个if 语句 为什么总是要执行到 ServerMessage:性别信息错误' 报错这里 不管我填写@SEX正确与否

DECLARE @sex varchar(50) = '';
DECLARE @name varchar(100) = '';
DECLARE @I_ReturnMessage varchar(100)
SET @Sex='女'
BEGIN
if(@Sex = '男' or @Sex = '女')
begin
SELECT 1
end
else
begin
set @I_ReturnMessage = 'Message:性别信息错误'
SELECT @I_ReturnMessage
end
END
测试没问题

@sex 只定义没赋值。
请用set赋值再说