摘要： ALTER FUNCTION [dbo].[GetGenderByPeopleID] (@id VARCHAR(18))RETURNS nchar(1)ASBEGINDECLARE @sex AS varchar(3),@gender AS nchar(1)IF LEN(@id)>=15beginif len(@id)=18 begin set @sex=substring(@id,15,3... 阅读全文