Functions Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
Functions are subroutines that you define so you can reuse code without having to reinvent the wheel each time. You can use functions to determine the best methods for controlling access and manipulation of the underlying data contained in an object. A function returns a value, unlike a stored procedure, which does not.
- To create a user-defined function, you need CREATE ANY privileges or IMPLICIT_SCHEMA authority on the database if the schema does not already exist.
To create a new function using a wizard:
- Open a creation wizard for a function. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Functions (SQL Server) - Properties.
- Definition panel - for details, see Functions (SQL Server) - Definition.
- Finally, use the Execute button to create the object.
Functions (SQL Server) - Properties
When creating or editing a function, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
| Owner | Select the owner of the function. |
| Name | Provide a name for the function. |
| Schema Binding | Choose whether the function is bound to database objects that it references. |
| Encryption | Choose whether SQL Server encrypts table columns that contain the text of the CREATE FUNCTION statement. |
| Native Compilation | This option sets natively-compiled functions that allow for efficient query execution within the stored procedure. |
Functions (SQL Server) - Definition
Complete the CREATE FUNCTION outline provided by typing or pasting the body of the function.