1
I am trying in my service to create temporary tables as I have always learned, putting # in front of the name I want. But I don’t know what happens when I create one, it puts a huge underscore and some random things after the name. Example, I created the table #TEMP, then he creates the table #TEMP___________________________________0000004, as per print.
4
This is a feature of MS SQL Server. It adds these _ and then an identifier to know which connection it came from, so if another connection creates a temporary table with the same name will not have problems.
Nothing to worry about, can continue using normally only with the #temp.
More information: https://stackoverflow.com/a/19670997/266569
Thank you very much!
Browser other questions tagged sql sql-server
You are not signed in. Login or sign up in order to post.
Hi, how about try using Function Table? Works very well and works directly on the server memory.
– Alberto Cláudio Mandlate