The maximum length of the name for a temporary table in SQL Server 2008 is 128 characters. The last 12 characters are reserved, therefore only 116 can be effectively used. It is worth noting that the first character should be the '#' if the table is a local temporary table. Also the first two characters should be the '#' if the table is a global temporary table.
Abonați-vă la:
Postări (Atom)
