Procedury DAIS

CREATE PROCEDURE RemoveGroup
--ALTER PROCEDURE RemoveGroup
(@id INTEGER)
AS
BEGIN
    BEGIN TRANSACTION deletingGroup
        UPDATE users SET group_id = NULL WHERE group_id = @id
        DELETE FROM groups WHERE id = @id
    COMMIT
END
GO