Sunday , 25 June 2017
Home » Tag Archives: functions

Tag Archives: functions

Stored Procedure vs Functions

Stored Procedure vs Functions In this article I am going to show you the differences between a Function and a Stored Procedure in sql server. They are both stored in the database server. First let me show you how you can create user defined function and a stored procedure. I am going to create a simple function that will add …

Read More »

Scalar Functions in SQL Server

Scalar Functions in SQL Server Scalar functions in SQL Server return a single value, based on the input value  Below there is a list of Scalar functions and in this article I am going to show you how Scalar Functions are working with an example. UPPER() – Converts a field to upper case LOWER() – Converts a field to lower …

Read More »

Functions in SQL Server

Functions in SQL Server Function is a database object in SQL Server. It is a set of sql statements that accepts only input parameters. Functions can return single value or table. You can not get multiple results from one function. There are 2 types of functions in sql server.  System Defined Functions and User Defined Functions. In system defined functions is …

Read More »