EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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 SQL Editor 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.