Local Temp Table Vs Global Temp Table

Local Temp Table Vs Global Temp Table

S.No	Particulars	Local Temp Table	Global Temp Table
1	Available	SQL Server session or connection (means single user).	all SQL Server sessions or connections (means all the user).
2	Deleted	These are automatically deleted when the session that created the tables has been closed.	These can be created by any SQL Server connection user and these are automatically deleted when all the SQL Server connections have been closed.
3	Stared with sign	Local temporary table name is stared with single hash ("#") sign.	Global temporary table name is stared with double hash ("##") sign.

Store Procedure Vs Function

Store Procedure Vs Function

S.No	Particulars	Store Procedure	Function
1	Return	No return value.	Must return Value.
2	Parameter	Input/Output.	Input.
3	Call	can't called to Function.	can called to Store Procedure.
4	Mandatory Input Paramenter	not Mandatory.	Mandatory.
5	DML/Select	Allow DML/Select.	Allow Select.
6	Exception	can be handled.	can not be handled .

Primary Key vs Unique Key

Primary Key vs Unique Key

S.No	Particulars	Primary Key	Unique Key
1	null value	can't accept null values.	can accept Only One null value.
2	key	only one Primary key in a table.	more than one Unique key in a table.

Primary Key vs Foreign Key

Primary Key vs Foreign Key

S.No	Particulars	Primary Key	Foreign Key
1	null value	can't accept null values.	can accept Only One null value.
2	key	only one Primary key in a table.	more than one foreign key in a table.

Store Procedure Vs LINQ

Store Procedure Vs LINQ

S.No	Particulars	Store Procedure	LINQ
1	Faster	Faster than LINQ.	Slower than Store Procedure.
2	Debug	Not Allowed.	Allowed.
3	writing complex queries	Best Way.	Not Possible.
4	Deploy	SQL script for deployment.	easy and simple.