January 4, 2004 at 5:06 am
Following Features I Wish SQL Server Had ?
In if we are updating Multiple rows in a single SQL Query,
We dont have to have a cursor in Triggers to handle it.
You write logic for 1 Row and the rest it taken care unlike
in MS SQL Server you need to make use of cursors and traverse.
InterBase provides "Before Post" and "After Post" Triggers and
are "INSERTED" system table is updatable. Helps in putting default
values in to the required fields.
January 4, 2004 at 6:36 am
Why not to use an INSTEAD OF trigger?
Also if you define default for a specific column and during the insert you are providing NULL values to thoses columns, the default values will automatically (ie. without trigger) applied.
What is exactly the problem?
Bye
Gabor
Bye
Gabor
January 9, 2004 at 1:25 am
Can you give an example?
I tend to design my tables with rules and defaults so I am not sure why you need a trigger to enforce this?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply