Exportar (0) Imprimir
Expandir Tudo
Expandir Minimizar
Este artigo foi traduzido por máquina. Coloque o ponteiro do mouse sobre as frases do artigo para ver o texto original. Mais informações.
Tradução
Original

SqlDbType Enumeração

Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter.

Namespace:  System.Data
Assembly:  System.Data (em System.Data. dll)

public enum SqlDbType

Nome do membroDescrição
BigInt Int64 .Um inteiro de 64 bits com sinal.
Binary Array of type Byte.Um fluxo de comprimento fixo de dados binários que variam entre 1 e 8.000 bytes.
Bit Boolean .An unsigned numeric value that can be 0, 1, or null.
Char String .A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
DateTime DateTime .Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
Decimal Decimal .A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.
Float Double .A floating point number within the range of -1.79E +308 through 1.79E +308.
Image Array of type Byte.A variable-length stream of binary data ranging from 0 to 2 31 -1 (or 2,147,483,647) bytes.
Int Int32 .Um inteiro de 32 bits com sinal.
Money Decimal .A currency value ranging from -2 63 (or -9,223,372,036,854,775,808) to 2 63 -1 (or +9,223,372,036,854,775,807) with an accuracy to a ten-thousandth of a currency unit.
NChar String .A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
NText String .A variable-length stream of Unicode data with a maximum length of 2 30 - 1 (or 1,073,741,823) characters.
NVarChar String .A variable-length stream of Unicode characters ranging between 1 and 4,000 characters.Conversão implícita falhará se o Cadeia de Caracteres é maior 4.000 caracteres.Set the objeto explicitly When Working with Cadeia de caracteres longer than Characters 4,000.
Real Single .A floating point number within the range of -3.40E +38 through 3.40E +38.
UniqueIdentifier Guid .Um identificador globalmente exclusivo (ou GUID).
SmallDateTime DateTime .Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
SmallInt Int16 .Um inteiro de 16 bits com sinal.
SmallMoney Decimal .A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.
Text String .A variable-length stream of non-Unicode data with a maximum length of 2 31 -1 (or 2,147,483,647) characters.
Timestamp Array of type Byte.Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows.O tamanho de armazenamento é 8 bytes.
TinyInt Byte .Um inteiro de 8 bits sem sinal.
VarBinary Array of type Byte.Um fluxo de dados binários que variam entre 1 e 8.000 bytes de comprimento variável.Conversão implícita falhará se a matriz de bytes é maior que 8.000 bytes.Explicitly Set the Objeto When Working with byte Arrays than 8,000 bytes.
VarChar String .Um fluxo de comprimento variável de caracteres não-Unicode que variam entre 1 e 8.000 caracteres.
Variant Object .A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared.
XmlUm valor XML.Obtain the XML as a string using the GetValue method or Value property, or as an XmlReader by calling the CreateReader method.
UdtA SQL Server 2005 tipo User-defined (UDT).
Structured
Date
Time
DateTime2
DateTimeOffset

Contribuições da comunidade

ADICIONAR
Mostrar:
© 2014 Microsoft