qds.spDeleteChkItem

Deletes a checklist item (`chkItemId`) and all its associated events and attribute links. It also nullifies any checklist item triggers that point to it.

- `@chkItemId` (int): ID of the checklist item to delete.

- Deletes from `chkItemEvent`, `chkItemAttrLink`, and `chkItem`. - Updates `chkItemTriggerId` to null if referencing this item.

Total number of deleted rows.

Code Example

-- Example: Delete a checklist item with ID 123
EXEC qds.spDeleteChkItem @chkItemId = 123;