左外连接

CREATE PROCEDURE [dbo].[up_AccountItemSelectALL]

AS

SELECT a.AccountGuid, a.AccountCategory, a.AccountName, a.AccountFSCode, a.DICGuid, a.IsObsoleted, d.DepartmentName, d.DepartmentCode FROM dbo.T_AccountItem AS a

LEFT OUTER JOIN dbo.T_Department AS d

ON a.DICGuid = d.DepartmentGuid

ORDER BY a.AccountCategory

 

 

create proc up_DeleteEmp2DeptBYGuid

@EmployeeGuid uniqueidentifier

as delete from dbo.T_Emp2Dept where EmployeeGuid=@EmployeeGuid