@comp_id int,
@sort_id int,
@prod_year varchar(6) = null,
@prod_no varchar(6),
@checkman_id int,
@flag bit
@sort_id int,
@prod_year varchar(6) = null,
@prod_no varchar(6),
@checkman_id int,
@flag bit
我在存储过程中是按@prod_year的null为条件做的判断