how to use function and stored procedure in SQL Server ?
Stephen West ~
Modified: September 21st, 2015 ~ ~ 1 Minute Reading
- This topic has 2 replies, 3 voices, and was last updated 8 years, 6 months ago by .
Viewing 3 posts - 1 through 3 (of 3 total)
-
Posts
-
You can use a function anywhere that you can use a scalar value or a table. Functions can be used in constraints, computed columns, joins, WHERE clauses, or even in other functions. Functions are an incredibly powerful part of SQL Server. Also you can use stored procedures when want to allow modular programming, faster execution, reduce traffic and also you can use Stored procedures in security mechanism
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.
Viewing 3 posts - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.