sqlserver isempty

create                    function IsEmpty(@a varchar(200),@b varchar(200)) returns varchar(200)
as
/*
*/
begin
declare @rtn varchar(200)
select @rtn=''
select @a=isnull(@a,'')
if @a=''
begin
select @rtn=@b
end
else
begin
select @rtn=@a
end
return @rtn
end
原文地址:https://www.cnblogs.com/kuailewangzi1212/p/2087345.html