General information
Forum:
Microsoft SQL Server
I have to move on. This seems like a major SQL bug, and since I have the stored Proc, I can't spend any more time on it.
I have no problem with this simple use of Instead Of Insert Trigger into the a view.
I can put 1000 rows into the view,
the trigger can split the view,
generate the 1000 new identities
and fill the 1000 dependant row correctly.
No bugs.
If you want use SCOPE_IDENTITY( ) for a complex triggers path, then problems occurs.
Fabio
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only