20141120 tempdb,object_id (SQL Server)

tempdb:

This is a temporary DB in SQL Server where you can declare a temporary table (#tablename) and destroy it after you run out of temporary tables.

Object_ID (Object Name,object type):

This function is built into SQL serve to find the object ID of the object being set, the first parameter is the object name, the second is the object type, or it can be retrieved only with the object name

For example Select object_id (' AA '), returns the ID of AA if AA exists, then returns NULL if it does not exist

20141120 tempdb,object_id (SQL Server)