How to share data between two session not using temp table

Sudip Bhatt 2,276

Please tell me how two session can share data between them without using temporary table, please discuss all possible ways where one session can store data and other session can read data.

thanks

Viorel 116.6K Reputation points

2020-11-08T21:35:07.12+00:00

Did you check if ;SEND and ;RECEIVE can be considered too: https://learn.microsoft.com/en-us/sql/t-sql/statements/send-transact-sql?
Erland Sommarskog 109.8K Reputation points MVP

2020-11-08T21:47:41.973+00:00

It's correct that Service Broker could be an option, but we really need to know what Mr. Bhatt's actual scenario is. The question is far too vague.
Sudip Bhatt 2,276 Reputation points

2020-11-10T16:43:49.853+00:00

Sir please discuss with a example how one can use service broker to share data between multiple different sql server session.
Erland Sommarskog 109.8K Reputation points MVP

2020-11-10T22:01:23.657+00:00

Sir, please describe your actual scenario, and we can tell whether Service Broker could be a fit.

It depends quite a bit on what you mean with session etc. But if we are talking to two spids, nah, it seems a little far-fetched at first glance. But there could be some special case where it makes sense.

So explain your actual situation, and we can advice you.

Accepted answer

EchoLiu-MSFT 14,581 Reputation points

2020-11-09T08:27:43.707+00:00

Hi @Sudip Bhatt ，

Could you describe the problem more clearly? In addition, if the temporary table can work, then why don't we choose it?

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Regards
Echo

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October--https://learn.microsoft.com/en-us/answers/questions/142427/users-always-get-connection-timeout-problem-when-u.html
Please sign in to rate this answer.
Sudip Bhatt 2,276 Reputation points

2020-11-09T14:51:40.01+00:00

I think ##table global temporary table i can use to share data between two session. out of curiosity i like to know what other options available for this purpose other than temp table. thanks

Erland Sommarskog 109.8K Reputation points MVP

2020-11-09T22:06:15.813+00:00

Global temp tables are very funny creatures. The practical use of them is negligible.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Erland Sommarskog 109.8K Reputation points MVP

2020-11-08T19:51:14.483+00:00

If you mean two sessions, that would have to be permanent tables, nothing else. (And temporary tables would not cut it).

It could help if you could clarify your scenario, so that we can help you better.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to share data between two session not using temp table

1 additional answer

Your answer