Procedure: [AdventureWorks2016CTP3].[Person].[sp_DeletePerson_Temporal]

CollapseAll image

Collapse image Procedure properties


 Name   Value 
 Schema   [Person] 
 Owner   [dbo] 
 Creation date   23.10.2015 
 Type   P 
 Encrypted   
 ID   1950629992 
 Implementation type   Transact SQL 
 Is native compiled   

Collapse image Creation options


Name Value
QUOTED_IDENTIFIER ON
ANSI_NULLS ON

Collapse image Parameters


Name  Description Datatype  Max length  Type  ReadOnly
@BusinessEntityID   int 4 Input  

Collapse image Objects that [Person].[sp_DeletePerson_Temporal] depends on


Object name Object type Dep level
[Person] Schema 1
[HumanResources].[Employee_Temporal] Table 1
[Person].[Person_Temporal] Table 1
Total 3 object(s)

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

/*
    Stored procedure that deletes row in [Person].[Person_Temporal]
    and corresponding row in [HumanResources].[Employee_Temporal]
*/
CREATE PROCEDURE [Person].[sp_DeletePerson_Temporal]
@BusinessEntityID INT
AS

DELETE FROM [HumanResources].[Employee_Temporal] WHERE [BusinessEntityID] = @BusinessEntityID;
DELETE FROM [Person].[Person_Temporal] WHERE [BusinessEntityID] = @BusinessEntityID;

GO

Collapse image See also


List of procedures