• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
• Download
• Purchase

MS SQL Maestro online Help

Specifying aggregate options

Several options can be specified for the aggregate function that govern the expected behaviour of the function. The detailed description is given below.

Owner

Defines the owner of the new aggregate. By default, only the owner of an object can perform various operations with the object. In order to allow other users to operate it, privileges must be granted. (However, users that have the superuser attribute can always access any object.)

Comment

The box allows you to set optional text to describe the new aggregate.

Parameter Name

The field represents a parameter in the user-defined aggregate. The value of the parameter must be supplied by the user when the aggregate function is executed.

Input Type

Defines the type of parameter.

Return Type

Defines the return type of the aggregate function.

CLR

Specifies the assembly to bind with the user-defined aggregate function and the name of the class in the assembly that implements the user-defined aggregate. The assembly is to have been already created in the database.

See also: Assemblies