Procedure:
[AdventureWorks2016CTP3].[Person].[sp_DeletePerson_Temporal]
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 |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
Parameters
| Name | Description | Datatype | Max length | Type | ReadOnly |
| @BusinessEntityID | int | 4 | Input |
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 |
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 |
See also