What is Function in Sql Server

Chittaranjan Swain

7y1.2k

Hi All,

What is Function in Sql Server and how to use with examples.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews7y ago
Accepted answer
If you need a computed value from your tables, User Defined Function can use. For example Sum of certain column values, average of certain values etc...
Functions have Only READ-ONLY database access. So no modification to database objects possible. If DML operations would be allowed in functions, then functions would be pretty similar to stored procedures. The way it is, a stored procedure can use a function, but not vice versa. Therefore, functions increase the “power” of stored procedures, queries and T-SQL scripts

There are many built-in functions available, which you can use in your queries. Ref. here for buit-in functions, https://www.w3schools.com/sql/sql_ref_sqlserver.asp
Priyanka Singh7y ago
Hey,

visit this link and you will clearly understand

https://www.janbasktraining.com/blog/different-types-sql-server-sql-database-functions/
Mohsin Arif7y ago
hey also follow this links
http://www.sqlservertutorial.net/sql-server-user-defined-functions/sql-server-scalar-functions/

https://www.c-sharpcorner.com/UploadFile/b926a6/function-operation-in-sql-database/
Kaushik Dudhat7y ago
A function is a database object in SQL Server. Basically, it is a set of SQL statements that accept only input parameters, perform actions and return the result. A function can return an only single value or a table.

Types of SQL Server Functions:
System Defined Functions
And in the system-defined function, we have 2 types of functions.
System Scalar Function
System Aggregate Function