SQL Server: save temporary table on cache

How I can sa开发者_JS百科ve SQL Server temporary table on cache?

Any ideas?

There is no feature in MSSQL that I know that supports what you want. You will need to handle it your self by saving to a normal table, but then you would need create your own unique session key and save in a table with the session key appeneded. But that can get messy. Can you store that data in a normal table instead?