BUG: SQL Server Books Online Does Not Display DELETE as an Option in the CREATE TRIGGER Topic (288395)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q288395
BUG #: 351664 (SHILOH)
BUG #: 235437 (SHILOH)
SYMPTOMS
The Syntax heading of the CREATE TRIGGER topic in SQL Server Books Online does not state that DELETE triggers can be created although it is possible to create DELETTE triggers.
The syntax shown in SQL Server Books Online is:
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask )
{ comparison_operator } column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
}
}
Note that [DELETE][,] is missing in line 5.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000 Books Online.
MORE INFORMATION
The DELETE keyword is included under the Arguments heading of the CREATE TRIGGER topic.
Modification Type: | Major | Last Reviewed: | 10/3/2003 |
---|
Keywords: | kbBug kbpending KB288395 |
---|
|