"If at first you don't succeed; call it version 1.0" :-Unknown

Pages

Sunday, May 29, 2011

Differentiate Local Temporary table and Global Temporary table

You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions. Prefix local temporary table names with single number sign (# table_name), and prefix global temporary table names with a double number sign (##table_name). 



Have a nice day... 'N happy Coding :)

No comments: