set @param = '16039cd8-5442-4aa3-8fb6-aa21670af396';
select
@param;
select
pb.id,
pb.ParentId ,
pb.FullName
from
po_baseinfo pb
where
@param is null
or pb.Id = @param
or pb.ParentId = @param
order by
pb.FullName;
set @param = '16039cd8-5442-4aa3-8fb6-aa21670af396';
select
@param;
select
pb.id,
pb.ParentId ,
pb.FullName
from
po_baseinfo pb
where
@param is null
or pb.Id = @param
or pb.ParentId = @param
order by
pb.FullName;