MS SQL functions

Delete a SQL Server function with a script

How to delete a SQL Server function with a script ? Or how to drop a SQL Server function, also called user-defined function? This SQL command allows to get rid of a SQL Server function. However, it does not check if the function exists. This article shows how to do this with a very simple example. How to delete a SQL function with a script

MS SQL functions

How to call a SQL Server function ?

How to call a SQL Server user defined function ? The SQL syntax to call a function is different from the call to a stored procedure. Use SQL Server function the same way you select data from a table. A user-defined SQL Server function is a Transact-SQL program that accepts parameters as input. When called, it performs actions, such as reading a SQL table

MS SQL functions

Modify a SQL Server function with alter function

How to modify a SQL Server function with Alter Function ? 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 city, separated with

MS SQL functions

Manage SQL Server user defined functions

How to manage SQL Server user defined functions ? SQL Server user-defined functions are very useful when starting T-SQL development. 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 functions is an exact science. There is