Get the value of a dynamically selected column

[JuanSanchez]

I have a trigger where I dynamically select which column was updated, the only problem I have is once I have the column I cant seem to get the new value of the column.

So basically I want to look at a table figure out which column was updated and return that column name and its value.

Any Ideas

 

[jgoodman00]

declare @sql varchar(1000)
declare @somecol varchar(50)
set @somecol = 'refno'
set @sql = 'select ' + @somecol + ' from adopt'

print @somecol
exec (@sql)

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures