TR_BANKACCOUNTADJUSTMENTNOTE_INSERT_HTMLPOPULATE

Trigger Definition

				
				CREATE trigger TR_BANKACCOUNTADJUSTMENTNOTE_INSERT_HTMLPOPULATE on dbo.BANKACCOUNTADJUSTMENTNOTE 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.BANKACCOUNTADJUSTMENTNOTE
						set HTMLNOTE = dbo.UFN_BUILDHTMLNOTE(TEXTNOTE)
						where ID = @INSERTEDID
					end
				end