已知用户姓名通过函数获得该用户微信钉钉ID号

1. CREATE FUNCTION [dbo].[GetWDID](@USERNAME VARCHAR(50))
   
2. returns VARCHAR(50)
   
3. as
   
4. Begin
   
5. declare  @return VARCHAR(50)
   
6.   
   
7.     Begin
   
8.   SELECT @return = [WDID] FROM [dbo].[SYS_USER] WHERE USERNAME = @USERNAME
   
9. End
   
10. return(@return)
    
11. End
    
12. GO

复制代码

已知用户姓名通过函数获得该用户微信钉钉ID号

1. CREATE FUNCTION [dbo].[GetWDID](@USERNAME VARCHAR(50))
   
2. returns VARCHAR(50)
   
3. as
   
4. Begin
   
5. declare  @return VARCHAR(50)
   
6.   
   
7.     Begin
   
8.   SELECT @return = [WDID] FROM [dbo].[SYS_USER] WHERE USERNAME = @USERNAME
   
9. End
   
10. return(@return)
    
11. End
    
12. GO

复制代码