forum

Home / DeveloperSection / Forums / How to create global temporary table in Sqlserver.

Ask Question

How to create global temporary table in Sqlserver.

Anonymous User 1433 30-Oct-2015
Can anyone please help me how to solve this problem.
.net sql server  sql 
Updated on 30-Oct-2015
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

30-Oct-2015
SQL Server provides the concept of temporary table which helps the developer in a best way. These tables can be created at runtime and can do the all kinds of operations that one normal table can do. But, based on the table types, the scope is limited. These tables are created inside tempdb database. 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.

 
 --step 1 create global temporary table

CREATE TABLE ##globaltemptbl( 
OrderID int,
rderdate datetime, amount decimal(10,2)  
); 
--step-2 insert data in #globaltemptabl from order table 

insert into ##globaltemptbl select * from [Order]
--step-3 select data from #globaltemptabl
select * from ##globaltemptbl
answer 415873010022941

Liked By