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.Hi,
you maye use a variable to generate the whole statement then use the exec command
Declare @.sql NVarchar(200)
set @.sql= "Select " + @.Fiels +" from inserted"
exec @.sql
No comments:
Post a Comment