摘要：函数:CREATE FUNCTION [dbo].[UF_XA_UserDataSearch_DepartmentSearch_V40] ( @DepID INT ) RETURNS TABLE AS RETURN ( WITH data AS ( SELECT dt.DepID , dt.DepFatherID FROM dbo.SysDepartment dt WITH (NOLOCK) WHERE dt.DepDelState = 1 AND ( @DepID = -1 OR dt.DepID = @DepID ) UNION ALL SELECT A1.DepID... 阅读全文