sql server 2005 - Create a table called #test, and create a table called test in the tempdb, what's the difference? -

In SQL Server 2005 (2008 has not been tested), you will see a temporary function such as #function_name , But you can create a funkastin directly called tempdb function_name . Is this a function created in a temporary function like this? A table named #table_name and directly tempdb ?

The temporary table (#test) is not actually said in the #Test tempb database This is because every user on the system can create a named named #test if you create a temp object in the tempdb database (see the sys.all_objects catalog view). In my case, it was created as "#Text _______________________________________________________________________________________________________________ 000000000003" Where you create a physical table in the Tempdi database, it is called a test, and only one experiment can create an object at a time, and if multiple user data is called a test in the physical table, then they will be able to access each other data. Where you have users of temporary tables, they can only access their own data and their tables.