Local Variable: The scope or lifetime of the local variable is within a block or procedure.. E.g.: DECLARE @Variable1Global Variable: The scope or lifetime of the global Variable throughout the execution of the program. E.g.: DECLARE @@Variable1

local variable has scope within same session while globle variable has scope in all sessions

difference between local table and a global table!!!!!! then 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.