Difference between Local Temp Table and Global Temp Table ?

What is the difference between Local Temp Table and Global Temp Table ?

Temporary tables are temporary storage structures.
You may use temporary tables to store data that you
will manipulate before arriving at a final format. 
 

Local Temp Table: 

The hash (#) character (prefix with tablename) is used to declare a temporary table 
as it is prepended to the table name. A single hash (#) specifies a local temporary table.
 Local temporary tables are available to the current connection for the user, so they 
disappear when the user disconnects. Within SQL Server, temporary tables are stored 
in the Temporary Tables folder of the tempdb database.

Syntax for creating Local Temp Table

Create table #tempLocalTableName(EmpId int, EmpName varchar(50), EmpAdd varchar(100))

Global Temp Table:

Global temporary tables may be created with double hashes (##) (Prefix with table name).
 These are available to all users via all connections, and they are deleted only when all
 connections are closed. Once created, these tables are used just like permanent tables;
 they should be deleted when you are finished with them. 

Syntax for creating Temp Table

Create table ##tempGlobalTableName(EmpId int, EmpName varchar(50), EmpAdd varchar(100))

If you like this post share it.. If you encounter any problems, feel free and

comment below to find solution. Share Your Experience with us.

 

Read More

Difference between Stored Procedure and Function In Sql

Hello Friends,

Today I am writing this post because of this is very important question in interview 

Inside procedure we can use DML (Insert /Update/Delete) statements, But Inside function we can not use DML statements.

Procedure can have both input\output parameters,  But Function can have only input parameter.

We can use Try-Catch Block in Stored Procedure, But In Function We can not use Try-Catch block.

We can not use Stored Procedure in Select statement, But In Function We can use in Select statement.

Stored Procedure can return 0 or n values (max 1024), But Function can return only 1 value which is mandatory.

Stored Procedure can not be call from Function, But We can call function from Stored Procedure.

We can use transaction in Stored Procedure, But In function we can not use transaction.

We can not use Stored Procedure in Sql statement anywhere in the Where/Having/select section, But In function we can use.

We can not join Stored Procedure, But we can  join function.

If you like this post share it.. If you encounter any problems, feel free and comment below to find solution. Share Your Experience with us.

Read More