Function vs. Stored Procedure in SQL Server

by

Functions are computed values and cannot perform permanent environmental changes to SQL Server (i.e., no INSERT or UPDATE statements allowed).

A function can be used inline in SQL statements if it returns a scalar value or can be joined upon if it returns a result set.

A point worth noting from comments, which summarize the answer. Thanks to @Sean K Anderson:

Functions follow the computer-science definition in that they MUST return a value and cannot alter the data they receive as parameters
(the arguments). Functions are not allowed to change anything, must
have at least one parameter, and they must return a value. Stored
procs do not have to have a parameter, can change database objects,
and do not have to return a value.

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. SQL Server – How to lock a table until a stored procedure finishes
  3. What is a stored procedure?
  4. How to assign an exec result to a sql variable?
  5. SQL Server SELECT into existing table
  6. How to check if a stored procedure exists before creating it
  7. Stored procedure that exports data into csv files only exports to one file
  8. SQL Query – Concatenating Results into One String [duplicate]
  9. Inserting rows into a table with one IDENTITY column only [duplicate]
  10. Eliminate and reduce overlapping date ranges
  11. Why do SQL Server Scalar-valued functions get slower?
  12. Is it possible to write single query on two table which are not connected to each other?
  13. How to create a specific SQL Server stored procedure? [closed]
  14. T-SQL: Deleting all duplicate rows but keeping one [duplicate]
  15. SQL: IF clause within WHERE clause
  16. Where value in column containing comma delimited values
  17. What is the difference between using a cross join and putting a comma between the two tables?
  18. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  19. Search text in stored procedure in SQL Server
  20. Pivot using SQL Server 2000
  21. Sequence vs identity
  22. How to update and order by using ms sql
  23. How to store image in SQL Server database tables column [duplicate]
  24. Procedure or function !!! has too many arguments specified
  25. Can I set ignore_dup_key on for a primary key?
  26. SQL Server replace, remove all after certain character
  27. How to find column names for all tables in all databases in SQL Server
  28. SQL Row_Number() function in Where Clause
  29. When using GETDATE() in many places, is it better to use a variable?
  30. Group consecutive rows of same value using time spans

Leave a Comment