Features In InterBase

  • 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.

  • 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

  • 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