use AdventureWorksCycles; EXEC DeleteCategory @CategoryID = ; -- input the category digit you would like to delete example ( 1; |or| 3;)