To create or alter a function
Complete the fields as necessary. Review the following for additional information:
General |
Description |
Parameters |
Click |
Return value |
Description |
Data type |
Select the data type for this function. |
Options |
Description |
Encryption |
Select whether to publish the function during SQL Server replication. |
Schema binding |
Select whether to bind the function to the schema of any objects the function references, such as tables or views. Attempting to alter or drop any object referenced by a schema-bound function fails if this checkbox is selected. |
ANSI Nulls |
Select whether to allow NULLs for functions that use SQL-92 NULL handling. |
Quoted Identifier |
Select whether to identify any strings that use a double quotation mark delimiter as an object identifier. |
On Null Input |
Select whether to accept null values when importing any empty fields from the file. |
User |
Specify the user context to use when executing the function. |
An assembly consists of .NET assemblies or COM DLLs used by the database or server.
Tip: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.
To create or alter an assembly
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create or alter an XML schema collection
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center