WHAT IS THE DIFFERENCE BETWEEN A LOCAL AND A GLOBAL VARIABLE?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
C# 
C#
 1370  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!