Parameter Object (Model Designer)

Defines a parameter to the query.

Properties

Name Cardinality Type Description

DataType

1

DataTypeEnum

The data type of the parameter. The user must enter a value that can be interpreted as the specified type. DataType cannot be Binary.

Nullable

0-1

Boolean

Indicates whether null is a valid value for this parameter.

Cardinality

0-1

Enum

Indicates whether this is a multivalue parameter that provides a set of the specified type. There are two options: One (Default) and Many.

Expression

0-1

Object

The default value for the parameter, if no value is supplied by the user. The Expression must be a literal or null, or a static function. If this element is not specified, a parameter value must be provided by the user. The expression must evaluate to the specified data type and cardinality. The expression may be a null value if the parameter is nullable.

Name

1

String

The name of the parameter.

Remarks

For more information about data types, see Model Designer Data Types.

See Also

Concepts

Model Designer Query Properties
Model Designer Object Properties
Model Designer
Model Designer Object Properties
Ad Hoc Reporting with Report Models
Working with Model Designer

Help and Information

Getting SQL Server 2005 Assistance