Online Documentation for SQL Manager for SQL server

Creating/editing UDF

Use the Function tab of UDF Editor to create/edit a user-defined function and specify its definition.


For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query Data area and Using the context menu.


UDF Editor - Editing UDF definition



Note: A UDF is a Transact-SQL or common language runtime (CLR) routine that returns a value. User-defined functions, like system functions, can be invoked from a query. Scalar functions can be executed by using an EXECUTE statement like stored procedures.


To execute a UDF, you can use the btnExecuteQuery Execute item available within the Navigation bar.