Category: DIFFERENCE

D

Differentiate OUT and RETURN in Stored Procedure

Difference between OUT and Return variables are described below: RETURN : RETURN is used when you want to return only

I

IDENTITY Vs SCOPE_IDENTITY() Vs IDENT_CURRENT in SQL Server

Below are the differences between Identity , Scope_Identity and Ident_Current in the SQL Server SELECT @@IDENTITY @@IDENTITY returns the latest

D

Difference Between Stored Procedure and Function in SQL Server

The basic differences between Stored Procedure and Function in SQL Server are given below :