TR_CONSTIT_SECURITY_ATTRIBUTE_INSERT (Trigger)

                
                    CREATE trigger dbo.TR_CONSTIT_SECURITY_ATTRIBUTE_INSERT on dbo.CONSTIT_SECURITY_ATTRIBUTE after insert not for replication
                    as begin
                        set nocount on;
                            
                        declare @ID uniqueidentifier;
                        declare @NAME NVARCHAR(100);
                        declare @CHANGEAGENTID uniqueidentifier;
                        
                        declare INSERTED_CURSOR cursor local fast_forward for
                            select
                                [ID],[NAME],[CHANGEDBYID]
                            from
                                INSERTED;
                                
                        open INSERTED_CURSOR;
                        
                        fetch next from
                            INSERTED_CURSOR
                        into
                            @ID,@NAME,@CHANGEAGENTID;
                            
                        while @@fetch_status = 0 begin
                            exec USP_CREATE_CONSTIT_SECURITY_ATTR_VIEW @ID, @NAME,@CHANGEAGENTID;
                        
                            fetch next from
                                INSERTED_CURSOR
                            into
                                @ID,@NAME,@CHANGEAGENTID;
                        end
                        
                        close INSERTED_CURSOR;
                        deallocate INSERTED_CURSOR;
                    end