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...

Read More