Monday, October 8, 2012

What does the SQL # symbol mean and how is it used?

They normally prefix temporary tables.
From the docs...
Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name).

http://stackoverflow.com/questions/3166117/what-does-the-sql-symbol-mean-and-how-is-it-used

No comments:

Post a Comment