已知部门ID获得部门名称的函数  

1. CREATE FUNCTION [dbo].[GetDeptName](@DeptID VARCHAR(50))
   
2. returns VARCHAR(50)
   
3. as
   
4. begin
   
5. declare  @return VARCHAR(50)
   
6.    
   
7.     Begin
   
8.           SELECT @return = [DEPTNAME] FROM [dbo].[SYS_VIEW_DEPT] WHERE DID = @DeptID
   
9.         End
   
10. return(@return)
    
11. end
    
12. GO
    
13. 
    

复制代码

已知部门ID获得部门名称的函数  

1. CREATE FUNCTION [dbo].[GetDeptName](@DeptID VARCHAR(50))
   
2. returns VARCHAR(50)
   
3. as
   
4. begin
   
5. declare  @return VARCHAR(50)
   
6.    
   
7.     Begin
   
8.           SELECT @return = [DEPTNAME] FROM [dbo].[SYS_VIEW_DEPT] WHERE DID = @DeptID
   
9.         End
   
10. return(@return)
    
11. end
    
12. GO
    
13. 
    

复制代码