Thursday, April 3, 2014

Best way to Share Data Between Stored Procedure and trigger

thanks for your answer @david.


but one problem when my store proc will create a temp table with a name #user_data then another user who can create temp table with same name or another user may execute that same store proc as a result store proc will create a temp table with same name so then there will be a clash & problem.


so i want to create a table with unique name for each sql server session. so please guide me. thanks

No comments:

Post a Comment