spTransactions_DeleteEventReg
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @id | int | IN |
Definition
Copy
CREATE procedure dbo.spTransactions_DeleteEventReg(@id int)
as
update dbo.EventTransactions set
IsDeleted=1, processed_date=getutcdate()
where EventTransactionsID=@id
delete from dbo.EventItemCapacity
where EventTransactionsID=@id