Physical Modeling › SQL Server 2005 Property Editors › Define SQL Server 2005 Aggregates

Previous Topic: SQL Server 2005 Property Editors

Next Topic: Define a SQL Server 2005 Asymmetric Key

Define SQL Server 2005 Aggregates

Use the SQL Server Aggregate Editor in a SQL Server 2005 physical model to define a user-defined function whose implementation is defined in a class of a .NET Framework assembly.

To define an aggregate in SQL Server 2005

  1. Click Target - SQL Server, Aggregates on the Model menu.

    The SQL Server Aggregate Editor opens.

  2. Select the aggregate in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new aggregate. Use the Enter filter text box to filter a very large list of aggregates to quickly locate the one that you want to define.

    Name

    Displays the aggregate name. You can change the aggregate name in this field.

    Schema

    Specifies the schema for the aggregate. Select a schema from the drop-down list or click the New icon to open the SQL Server Schema Editor and create one.

    Input Parameter Name

    Defines the input parameter name. For an acceptable syntax value for this field, see your Microsoft SQL Server documentation.

    Input Data Type

    Specifies the data type of the input parameter. Select a data type from the drop-down list.

    Return Data Type

    Specifies the data type of the return value. Select a data type from the drop-down list.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the General tab and work with the following options:
    Assembly

    Specifies the assembly that will bind with the aggregate function. Select an assembly from the drop-down list or click the New icon to open the SQL Server Assembly Editor and create one.

    Class Name

    Specifies the name of the class.

  4. (Optional) Click the Comment tab and enter any comments that you want to associate with the aggregate.
  5. (Optional) Click the Where Used tab to view where the aggregate is used within the model.
  6. (Optional) Click the UDP tab to work with user-defined properties for the aggregate.
  7. (Optional) Click the Notes tab to view history information and view or edit user notes.
  8. Click Close.

    The aggregate is defined and the SQL Server Aggregate Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor