You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/SQL-Triggers.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -126,7 +126,7 @@ Enforce business rules using BEFORE triggers:
126
126
-- Ensure product prices are positive
127
127
CREATETRIGGERvalidate_price BEFORE CREATE ON TYPE Product
128
128
EXECUTE SQL 'SELECT FROM Product WHERE @this = $record AND price > 0'
129
-
-- If SELECT returns no results, the trigger fails and creation is aborted
129
+
-- If this SELECT statement returns no results, the trigger fails and the operation is aborted. This provides a concise way to enforce data validation rules.
0 commit comments