How many types of Temporary Tables.
ajeet verma
There are two types of temporary table.1.Local Temporary Table: These are only available for the current instance, it will be automatically deleted when the user is disconnected from the instance. To create a local temporary table we use the table name with a # (hash) prefix.2.Global Temporary Table: This table is the same as a permanent table but the difference is only that when all the connections are closed or all the instances are deleted then the table will be deleted. To create a local temporary table we use a table name with a ## (double hash) prefix.if you want to know more about temp table then read my article : http://www.c-sharpcorner.com/UploadFile/75a48f/temporary-table-in-sql/
Local & Global
There are two types of Temporary Tables. 1-Local Table As- Create table #tblName () It exist only current window(In SQL Server)/Tab where we declare it. Out of this window/tab it destroy.2-Global Table As- Create table ##tblName() It exist in all window(in SQL Server)/Tab. And it destroy when all connections that have referenced them have closed.
There are two types of temporary table. 1.Local Temporary Table: # (hash) prefix 2.Global Temporary Table: ## (double hash) prefix
2
Temp table start with # symbol and that are two type : local and global.
Types : Local tables and global tables.
There is Two type of temporary table 1.Local temporary table 2.Global Temporary table
Two type of temporary table 1.Local temporary table 2.Global Temporary table
There is 2 types of Temporary tables and these are (1) Local Table (2)Global Table
Temporary Tables are two type 1 .Local Temporary Table for more detals go to this link http://www.mindstick.com/forum/33543/how-to-create-local-temporary-table-in-sqlserver 2 .Global Temporary Table for more detals go to this link http://www.mindstick.com/forum/33544/how-to-create-global-temporary-table-in-sqlserver
Temporary Tables are tow type 1 .Local Temporary Table for more detals go to this link http://www.mindstick.com/forum/33543/how-to-create-local-temporary-table-in-sqlserver 2 .Global Temporary Table for more detals go to this link http://www.mindstick.com/forum/33544/how-to-create-global-temporary-table-in-sqlserver
local and global
Plz refer. http://www.c-sharpcorner.com/UploadFile/97fc7a/local-and-global-temporary-tables-in-sql-server-2008/
ocal temp tables are only available to the current connection for the user; and they are automatically deleted when the user disconnects from instances. Local temporary table name is stared with hash ("#") sign. CREATE TABLE #LocalTempTable( UserID int, UserName varchar(50), UserAddress varchar(150))Global Temp Table-Global Temporary tables name starts with a double hash ("##"). Once this table has been created by a connection, like a permanent table it is then available to any user by any connection. It can only be deleted once all connections have been closed.CREATE TABLE ##NewGlobalTempTable( UserID int, UserName varchar(50), UserAddress varchar(150))
There Are Two Type 1-Local and Global
There are two types of temporary tables: local and global.
.
Two types of temporary Tables : Local and Global Local #tableName Global ##TableName