Temporary table with underscore

1

I'm trying on my service to create temporary tables as I've always learned by putting # in front of the name I want. But I do not know what happens when I create one, it puts a huge underscore and some random stuff after the name. For example, I created the #TEMP table, so it creates the #TEMP___________________________________0000004 table, as print.

    
asked by anonymous 27.06.2018 / 03:07

1 answer

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 it will not have problems.

Nothing to worry about, you can continue to use normally only with #temp .

More information: link

    
27.06.2018 / 18:38