Udostępnij za pośrednictwem

  • Artykuł

DataType Members

The DataType object represents a SQL Server data type.

The following tables list the members exposed by the DataType type.

Public Constructors

  Name Description
DataType Overloaded. Initializes a new instance of the DataType class.

Top

Public Properties

  Name Description
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif BigInt Gets a data type that specifies the BigInt definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Bit Gets a data type that specifies the Bit definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Date The Date property returns a Date data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif DateTime Gets a data type that specifies the DateTime definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Float Gets a data type that specifies the Float definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Geography The Geography datatype represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Geometry The Geometry property contains spatial data that represents information about the physical location and shape of geometric objects.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif HierarchyId The HierarchyId property is used to identify a position in a hierarchy.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Image Gets a data type that specifies the Image definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Int Gets a data type that specifies the Int definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif MaximumLength Gets the maximum length of the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Money Gets a data type that specifies the Money definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif Name Gets the name of the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif NText Gets a data type that specifies the NText definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif NumericPrecision Gets or sets the numeric precision of the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif NumericScale Gets or sets the numeric scale of the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif NVarCharMax Gets a data type that specifies the NVarCharMax definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Real Gets a data type that specifies the Real definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif Schema Gets or sets the schema of the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif SmallDateTime Gets a data type that specifies the SmallDateTime definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif SmallInt Gets a data type that specifies the SmallInt definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif SmallMoney Gets a data type that specifies the SmallMoney definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif SqlDataType Gets a data type that specifies the SqlDataType definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif SysName Gets a data type that specifies the SysName definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Text Gets a data type that specifies the Text definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Timestamp Gets a data type that specifies the TimeStamp definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif TinyInt Gets a data type that specifies the TinyInt definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif UniqueIdentifier Gets a data type that specifies the UniqueIdentifier definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif VarBinaryMax Gets a data type that specifies the VarBinaryMax definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif VarCharMax Gets a data type that specifies the VarCharMax definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Variant Gets a data type that specifies the Variant definition used in the data type.
ms219512.pubproperty(pl-pl,SQL.100).gif XmlDocumentConstraint Gets or sets a value that indicates how an XML document is formatted.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Binary Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Char Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif DateTime2 DateTime2 is an extension of the existing DATETIME type. It has a large date range and large default fractional precision. It has a length of at least 19 positions.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif DateTimeOffset Returns values for year, month, day, valid time of day between 00:00:00 and 23:59:59:9999999 and offset, in hours, from UTC. It has a length of at least 25 positions.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Decimal Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gif Equals Overloaded.  
ms219512.pubmethod(pl-pl,SQL.100).gif GetHashCode Overridden.  
ms219512.pubmethod(pl-pl,SQL.100).gif GetType  (inherited from Object )
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif NChar Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Numeric Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif NVarChar Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif ReferenceEquals  (inherited from Object )
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Time Returns values for any valid time of day between 00:00:00 and 23:59:59:9999999. It has a length of at least 8 positions and contains the time in hours,minutes, seconds and fractional seconds.
ms219512.pubmethod(pl-pl,SQL.100).gif ToString Overridden. Returns the object in string format.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif UserDefinedDataType Overloaded. Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif UserDefinedTableType Overloaded. Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif UserDefinedType Overloaded. Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif VarBinary Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif VarChar Returns an object that represents the specified type.
ms219512.pubmethod(pl-pl,SQL.100).gifms219512.static(pl-pl,SQL.100).gif Xml Overloaded. Returns an object that represents the specified type.

Top

Protected Methods

  Name Description
ms219512.protmethod(pl-pl,SQL.100).gif Finalize  (inherited from Object )
ms219512.protmethod(pl-pl,SQL.100).gif MemberwiseClone  (inherited from Object )

Top