SQL Server Functions

SQL Server functions example queries.

SQL Server

SQL Server Alter Function

February 11, 2019

How to update the code of an SQL Server function without deleting it? The solution is to update its definition using the SQL Server Alter Function command. The query updates the function already created in the database. This new code returns not only the customer name, but also the customer …

SQL Server Functions

SQL Server user-defined functions example queries

October 3, 2018

SQL Server user-defined functions are very useful when you start T-SQL development on SQL Server. You need to use them very often so you have to learn the right syntaxes and avoid errors. At the beginning it can be tricky and frustrating because it’s binary, it work or don’t work, programming T-SQL …