UserDefinedFunction Object
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。
The UserDefinedFunction object exposes the attributes of a single user-defined function.
Properties
|
Methods
解説
With the UserDefinedFunction object, you can:
- Create a Microsoft SQL Server user-defined function.
- Change the definition of an existing SQL Server user-defined function.
- Control access rights to an existing SQL Server user-defined function.
- Delete an existing SQL Server user-defined function.
- Generate a Transact-SQL script to re-create a SQL Server user-defined function.
The Name property of a UserDefinedFunction object uses the SQL Server sysname data type. The value of the Name property must be unique (named by owner) within a SQL Server database.
To create a SQL Server user-defined function
Create a UserDefinedFunction object.
Set the Name property.
Set the Text property to contain the user-defined function.
Set optional property values.
Add the UserDefinedFunction object to the UserDefinedFunctions collection of a connected Database object.
After a user-defined function is created, you cannot reset the Name property. To change the name of a user-defined function, you must call the Remove method to drop and then re-create the object.
メモ : |
---|
The UserDefinedFunction object is compatible only with SQL Server 2000 and later. |