Sunday , 25 June 2017
Home » Tag Archives: scalar function

Tag Archives: scalar function

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 »