Procedure:
[AdventureWorks2016CTP3].[Person].[sp_DeletePerson_Temporal]
Name | Value |
Schema | [Person] |
Owner | [dbo] |
Creation date | 23.10.2015 |
Type | P |
Encrypted | |
ID | 1950629992 |
Implementation type | Transact SQL |
Is native compiled |
Name | Value |
QUOTED_IDENTIFIER | ON |
ANSI_NULLS | ON |
Name | Description | Datatype | Max length | Type | ReadOnly |
@BusinessEntityID | int | 4 | Input |
Object name | Object type | Dep level |
[Person] | Schema | 1 |
[HumanResources].[Employee_Temporal] | Table | 1 |
[Person].[Person_Temporal] | Table | 1 |
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 |