Monday, March 19, 2012

how can I

How can I get a value from a variable in one trigger to populate a variable
in another trigger.Hi
Persist it to a table (not Temporary).
No global variables in SQL Server.
Regards
Mike
"seeker53" wrote:
> How can I get a value from a variable in one trigger to populate a variable
> in another trigger.|||You can't. Also, variables aren't very much use in a trigger. Don't assign
column values to variables in a trigger because that compels you to use
cursor processing to handle multiple row updates - or to disallow multi-row
updates altogether. Neither option is a good idea.
--
David Portas
SQL Server MVP
--

No comments:

Post a Comment