That is the SQL Functions are a database object in SQL Server. Mainly, it is a set of SQL statements that accept only input parameters, perform actions and return the result. A function can return only a single value or a table. You can’t use a function to Insert, Update, Delete records in the database tables.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
That is the SQL Functions are a database object in SQL Server. Mainly, it is a set of SQL statements that accept only input parameters, perform actions and return the result. A function can return only a single value or a table. You can’t use a function to Insert, Update, Delete records in the database tables.
Example:-