What is the difference between a local and a global variable? | SansSQL

Thursday, June 12, 2008

What is the difference between a local and a global variable?

A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection are closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.

1 comment:

Sandeep Molugu said...

The question is talking about VARIABLES, while your explanation is talking about temporary tables.

Post a Comment