ParameterBase.DataType Property

Article
07/16/2015

Applies To: SQL Server 2016 Preview

Gets or sets the data type associated with the parameter.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)]
[SfcReferenceAttribute(typeof(UserDefinedTableType), typeof(UserDefinedTableTypeResolver), 
    "Resolve", new string[] { ... })]
[SfcReferenceAttribute(typeof(UserDefinedDataType), typeof(UserDefinedDataTypeResolver), 
    "Resolve", new string[] { ... })]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(UserDefinedType), typeof(UserDefinedTypeResolver), 
    "Resolve", new string[] { ... })]
public virtual DataType DataType { get; set; }

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Standalone | SfcPropertyFlags::Design | SfcPropertyFlags::Matrix)]
[SfcReferenceAttribute((UserDefinedTableType^::typeid), (UserDefinedTableTypeResolver^::typeid), 
    "Resolve", new array<String^>^ { ... })]
[SfcReferenceAttribute((UserDefinedDataType^::typeid), (UserDefinedDataTypeResolver^::typeid), 
    "Resolve", new array<String^>^ { ... })]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute((UserDefinedType^::typeid), (UserDefinedTypeResolver^::typeid), 
    "Resolve", new array<String^>^ { ... })]
property DataType^ DataType {
    virtual DataType^ get();
    virtual void set(DataType^ value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)>]
[<SfcReferenceAttribute(typeof(UserDefinedTableType), typeof(UserDefinedTableTypeResolver),
    "Resolve", [| ... |])>]
[<SfcReferenceAttribute(typeof(UserDefinedDataType), typeof(UserDefinedDataTypeResolver),
    "Resolve", [| ... |])>]
[<CLSCompliantAttribute(false)>]
[<SfcReferenceAttribute(typeof(UserDefinedType), typeof(UserDefinedTypeResolver),
    "Resolve", [| ... |])>]
abstract DataType : DataType with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)>]
[<SfcReferenceAttribute(typeof(UserDefinedTableType), typeof(UserDefinedTableTypeResolver),
    "Resolve", [| ... |])>]
[<SfcReferenceAttribute(typeof(UserDefinedDataType), typeof(UserDefinedDataTypeResolver),
    "Resolve", [| ... |])>]
[<CLSCompliantAttribute(false)>]
[<SfcReferenceAttribute(typeof(UserDefinedType), typeof(UserDefinedTypeResolver),
    "Resolve", [| ... |])>]
override DataType : DataType with get, set

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Design Or SfcPropertyFlags.Matrix)>
<SfcReferenceAttribute(GetType(UserDefinedTableType), GetType(UserDefinedTableTypeResolver),
    "Resolve", New String() { ... })>
<SfcReferenceAttribute(GetType(UserDefinedDataType), GetType(UserDefinedDataTypeResolver),
    "Resolve", New String() { ... })>
<CLSCompliantAttribute(False)>
<SfcReferenceAttribute(GetType(UserDefinedType), GetType(UserDefinedTypeResolver),
    "Resolve", New String() { ... })>
Public Overridable Property DataType As DataType

Property Value

Type: Microsoft.SqlServer.Management.Smo.DataType

A DataType object value that specifies the data type associated with the parameter.

Remarks

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Legacy Code Example

Setting Properties

Creating, Altering, and Removing Stored Procedures