Database

vinay dahiya wrote:

lol....kid..

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Quote:

Another oddity of the local temporary table (and the local temporary stored procedure) is that it has a different name in the metadata to the one you give it in your routine or batch. If the same routine is executed simultaneously by several processes, the Database Engine needs to be able to distinguish between the identically-named local temporary tables created by the different processes. It does this by adding a numeric string to each local temporary table name left-padded by underscore characters. Although you specify the short name such as #MyTempTable, what is actually stored in TempDB is made up of the table name specified in the CREATE TABLE statement and the suffix. Because of this suffix, local temporary table names must be 116 characters or less.

#tmp_table__________________________________________________________________________________________________________000000000002

where t.name LIKE '#tmp_table%'

select c.* ,t.name from tempdb.sys.columns c
INNER JOIN tempdb.sys.tables t
on (c.object_id = t.object_id
and t.name = '#tmp_table');

and t.name LIKE '#tmp_table%'

and t.object_id = OBJECT_ID('tempdb..#tmp_table')

select c.* ,t.name from tempdb.sys.columns c
INNER JOIN tempdb.sys.tables t
on c.object_id = t.object_id
where t.object_id = OBJECT_ID('tempdb..#tmp_table')