Home > DeveloperSection > Interviews > What is the difference between a user defined function and a Stored procedure?

Posted on    January-21-2015 10:44 PM

 MSSQL Server SQL Server 
Ratings:
 1 Answer(s)
  468  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Points:400
Posted on    January-21-2015 11:44 PM

A user defined function and stored procedures are almost similar but there exists a difference between their implementation procedures in the code. Stored procedure needs to be invoked whereas a UDF can be used like any other statement.

Don't want to miss updates? Please click the below button!

Follow MindStick