Home » Reply » Reply To: how to use function and stored procedure in SQL Server ?

Reply To: how to use function and stored procedure in SQL Server ?

Lincoln Burrows ~ Modified: October 1st, 2015 ~ ~ 1 Minute Reading

Home › Forums › how to use function and stored procedure in SQL Server ? › Reply To: how to use function and stored procedure in SQL Server ?

October 1, 2015 at 10:23 am #772 Score: 0
Lincoln Burrows
Moderator
16 pts

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.