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