How to make a SELECT with a field name inside a variable?
I have a cursors than read the differents fiels tat have this table inside a trigger fron another table that contain all the fields of the tables.
This cursor save the name of the fiels inside the variable @FIELD.
I need to read the value of the several records of the table like:
@FIELD='NIF' <--(CURSOR)
SELECT @FIELS FEOM INSERTED --> select nif from inserted(persons)
This sentence doesn't works. How can I do?
Thanks, Otto Martinez.

