All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
307 views

Create trigger to ignore user input for Identity Columns

Using the this table definition CREATE TABLE testtable ( id NUMBER GENERATED AS IDENTITY, desc VARCHAR2(30) ); I would like to create a trigger before inserts and updates to ...
1
vote
1answer
130 views

INSTEAD OF INSERT trigger

Consider this a follow-up to BULK INSERT: Trials and Tribulations I have the following VIEW defined and would like to insert into the multiple underlying tables when sending a BULK INSERT from a CSV. ...
7
votes
1answer
2k views

Getting Identity values to use as FK in an INSTEAD OF trigger

I have a series of updateable views we are exposing to end users as the interface for a back end process. One of these views references two tables and requires an INSTEAD OF trigger for UPDATE and ...
8
votes
3answers
15k views

How to get last identity row Inserted when using instead of trigger

When I insert into tables using instead of triggers, @@Identity, IDENT_CURRENT('Table') and SCOPE_IDENTITY() return null. How I can get the last identity of inserted row?