[dba-SQLServer] Insert trigger question

Francisco Tapia fhtapia at gmail.com
Fri Jun 3 18:44:53 CDT 2005


If you are inserting via a sproc this is true, however it is best if
you add some error handling to make sure that you are only dealing w/
a single record, otherwise you may want to add the functionality to
handle a larger recordset, this can be true if you have other
procedures that insert multple records at a time, or if you end up
having to run an administrative task where you insert multiple records
at once.

On 6/3/05, Joe Rojas <JRojas at tnco-inc.com> wrote:
> If I have 20 records to insert into a table, in SS7, and I do it iteratively
> will my insert trigger execute 20 times?
> 
> Currently the trigger uses a cursor based off of the inserted table and
> fetches 1 record at a time but I'm thinking that if I perform the insert
> task as stated above that I don't need a cursor because there is only on
> record in the inserted table anyway.
> Am I right?
> 
> Thanks!
> JR
> 
> 
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list