关于存储过程 if else解决思路

关于存储过程 if else
CREATE PROCEDURE GET_T_STAFF
(
 @_StaffCode INT
)
AS BEGIN 
declare @_sql varchar(100)
set @_sql='select'
  set @_sql=@_sql+' StaffCode,LoginPw,StaffName,Sex,IDCode,GraduateSchool,EntryDate,IfStop FROM dbo.T_Staff WHERE 1=1'
if @_StaffCode >=1
begin
  set @_sql=@_sql+' and StaffCode=@_StaffCode'
end
  print @_sql

end

 这里GET_T_STAFF 输入参数 并没有进入IF判断 求解释

[解决办法]

SQL code

CREATE PROCEDURE GET_T_STAFF @_StaffCode as INTAS BEGIN    declare @_sql as varchar(800)  set @_sql = 'select'  set @_sql = @_sql + ' StaffCode , LoginPw , StaffName , Sex , IDCode , GraduateSchool , EntryDate , IfStop FROM dbo.T_Staff WHERE 1 = 1 '  if @_StaffCode >=1     set @_sql=@_sql + ' and StaffCode = ' + ltrim(@_StaffCode)  print @_sqlend