DIFFERENCE BETWEEN STORED PROCEDURES AND FUNCTIONS IN SQL | SQL Interview Question | IQBees

Published: 21 May 2021
on channel: IQBees

42,990

611

Hello Friends,

Difference between stored procedure and function is the most asked question in the interview. Most of us are aware about it but this video is for those who are new to sql or planning for an interview.

DIFFERENCE BETWEEN STORED PROCEDURES AND FUNCTIONS IN SQL

1. Stored Procedures are pre-compiled objects which are compiled for the first time and its compiled format is saved, which executes (compiled code) whenever it is called.

A function is compiled and executed every time whenever it is called.

2. An exception can be handled by try-catch block in a Procedure whereas try-catch block cannot be used in a Function.

3. We can use Transactions in Procedure whereas we can't use Transactions in Function.

4. The function must return a value but in Stored Procedure it is optional. Even a procedure can return zero or n values.

5. Functions can be called from Procedure whereas Procedures cannot be called from a Function.

6. The procedure allows SELECT as well as DML(INSERT/UPDATE/DELETE) statement in it whereas Function allows only SELECT statement in it.

7. Function can be used with Select, Where and Having Clause and even used with joins as well But, Can't use same with procedure

Regards,
IQBees

difference between functions and stored procedures in sql server,difference between functions and stored procedures in sql server hindi,difference between functions and stored procedures,difference between stored procedure and function in sql server in hindi,difference between stored procedure and function in sql server,difference between stored procedure and function,what is the difference between stored procedure and function in sql

#differencebetweenstoredprocedureandfunctioninsql #differencebetweenstoredprocedureandfunctioninsqlserver
#storedprocedureandfunction

On this page of the site you can watch the video online DIFFERENCE BETWEEN STORED PROCEDURES AND FUNCTIONS IN SQL | SQL Interview Question | IQBees with a duration of hours minute second in good quality, which was uploaded by the user IQBees 21 May 2021, share the link with friends and acquaintances, this video has already been watched 42,990 times on youtube and it was liked by 611 viewers. Enjoy your viewing!

6,750