Diffrence Between Stored Procedure And Function?

Question

Diffrence Between Stored Procedure And Function in Sql Serever?

Puneet Kankar · Answer

Naveen Bisht · Answer

one most important diffrance Function is compiled it will genrate the error at complie time while store proc will genrate the error at run time (time of exectuion). for eg. 1- create a store proc with simple select query with table(which is not exists) it will create but it will give you error at run time 2- while in same case fution will not create

Zakir Ahamed · Answer

Use this URL: http://www.c-sharpcorner.com/UploadFile/2072a9/store-procedure-vs-function-in-sql-server/ http://www.c-sharpcorner.com/UploadFile/996353/difference-between-stored-procedure-and-user-defined-functio/ https://stackoverflow.com/questions/1179758/function-vs-stored-procedure-in-sql-server