Is there any way to identify the name of the table last updated (just like @@identity provides the last updated row identity). We have a need to update one of several tables based on dynamic sql statement and then need to trigger further updates based on knowing the table name rather than previous selection criteria.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
identify table name
- Thread starter Windy77
- Start date
NoCoolHandle
Programmer
See what happens when you allow dynamic sql?
Life just keeps getting harder.
Have your dyanmic sql add (insert) a row to a table that identifies the table and that table would then trigger the next change..
bottom line.. NO there is not @@LastTableEffected variable.
sorry
Rob
Life just keeps getting harder.
Have your dyanmic sql add (insert) a row to a table that identifies the table and that table would then trigger the next change..
bottom line.. NO there is not @@LastTableEffected variable.
sorry
Rob
- Status
Similar threads
- Locked
- Question
- Locked
- Question