存储过程根据ouID获取IntlPerson数据表

/******************************************************************************
**		Name: usp_base_GetIntlPersonByOUID
**		Desc: 根据personid获取人员user和ou相关信息：
**
**              
**		Return Values:
** 				
**		Parameters:	
**		Auth:
**		Date:2008-12-3
*******************************************************************************/
ALTER proc usp_base_GetIntlPersonByOUID
	@OUID uniqueidentifier
as
begin
	select dbo.uf_GetOUName(a.OUID) OUName,c.UserID,C.UserName,
		a.*
	        from tbl_base_PersonInfo a 
                left join tbl_base_UserMapping b
		on a.PersonID = B.PersonID 
                left join tbl_base_User c
		on b.UserID = c.UserID
	where a.OUID = @OUID

end

　　

/*
根据OUID,获取单位名称
*/
ALTER FUNCTION [dbo].[uf_GetOUName] (
	@OUID as uniqueidentifier
) RETURNS varchar(200)
AS
BEGIN
	DECLARE @Ret varchar(200)
	
	SELECT @Ret =OUName
	  FROM VW_allou
	 WHERE OUID = @OUID

	RETURN @Ret

END

　　

转载于:https://www.cnblogs.com/liuqiyun/p/7640958.html