How to create and call scalar function in a store procedure for SQL Server 2012

SQL Server;s functions are a valuable addition to TSQL when used wisely. I will show you a basic example how to use scalar functions. Let’s start with a definition:¬†https://technet.microsoft.com/en-us/library/ms177499(v=sql.105).aspx     Scalar Functions User-defined scalar functions return a single data value of the type defined in the RETURNS clause. For an inline scalar function, there […]

Read More »