Minnu (11/25/2015)

---

Hi Team,

using below trigger,

ALTER TRIGGER [dbo].[t_info] ON [dbo].unify_info

FOR update

AS

begin

declare @val1 varchar(100) declare @val2 varchar(100) declare @temp varchar(100)

set @temp='HHT_Report'

set @val1='SELECT ' +@temp+ ' FROM INSERTED'

set @val2='SELECT ' +@temp+ ' FROM DELETED'

EXEC (@val1)

end

--

i want the result of below query's from above trigger.

SELECT HHT_Report FROM INSERTED

SELECT HHT_Report FROM DELETED