Online Documentation for SQL Administrator for SQL Server

Properties


Use the Properties tab of the Function Editor to create/edit a function and specify its definition.

 

Name

Enter a name for the new function. Note that function names must comply with the rules for identifiers and must be unique within the schema.

 

Function Editor - Properties

 

 

Schema

Use the drop-down list to select the schema which the function belongs to. The default selection is the default schema for the current user.

 

!CheckBox ANSI Nulls

This option specifies ISO compliant behavior of the Equals (=) and Not Equal To (<>) comparison operators when they are used with null values. When this option is switched on, a SELECT statement that uses WHERE column_name = NULL returns zero rows even if there are null values in column_name. A SELECT statement that uses WHERE column_name <> NULL returns zero rows even if there are nonnull values in column_name.

 

!CheckBox Quoted identifier

This option causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. When this option is switched on, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When it is switched off, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.

 

SQL

Use this text area to specify function definition as SQL statement.

You can click the Display object template button to replace the text field content with the function definition template.