TR_SURVEYNOTE_INSERT_HTMLPOPULATE (Trigger)

                
                CREATE trigger TR_SURVEYNOTE_INSERT_HTMLPOPULATE on dbo.SURVEYNOTE after insert not for replication
                as begin
                    declare @INSERTEDHTML nvarchar(max)
                    declare @INSERTEDID uniqueidentifier
                    
                    select @INSERTEDID = ID, @INSERTEDHTML = HTMLNOTE from inserted
                    if @INSERTEDHTML = ''
                    begin
                        update dbo.SURVEYNOTE
                        set HTMLNOTE = dbo.UFN_BUILDHTMLNOTE(TEXTNOTE)
                        where ID = @INSERTEDID
                    end
                end