All pastes #130783 Raw Edit

Nagappan

public text v1 · immutable
#130783 ·published 2006-08-14 05:18 UTC
rendered paste body
TypeName - smallint
ProviderDbType - 16
ColumnSize - 5
CreateFormat - smallint
CreateParameters - 
DataType - System.Int16
IsAutoIncrementable - True
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - True
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - int
ProviderDbType - 8
ColumnSize - 10
CreateFormat - int
CreateParameters - 
DataType - System.Int32
IsAutoIncrementable - True
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - True
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - real
ProviderDbType - 13
ColumnSize - 7
CreateFormat - real
CreateParameters - 
DataType - System.Single
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - float
ProviderDbType - 6
ColumnSize - 53
CreateFormat - float({0})
CreateParameters - number of bits used to store the mantissa
DataType - System.Double
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - money
ProviderDbType - 9
ColumnSize - 19
CreateFormat - money
CreateParameters - 
DataType - System.Decimal
IsAutoIncrementable - False
IsBestMatch - False
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - True
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - smallmoney
ProviderDbType - 17
ColumnSize - 10
CreateFormat - smallmoney
CreateParameters - 
DataType - System.Decimal
IsAutoIncrementable - False
IsBestMatch - False
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - True
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - bit
ProviderDbType - 2
ColumnSize - 1
CreateFormat - bit
CreateParameters - 
DataType - System.Boolean
IsAutoIncrementable - False
IsBestMatch - False
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - tinyint
ProviderDbType - 20
ColumnSize - 3
CreateFormat - tinyint
CreateParameters - 
DataType - System.SByte
IsAutoIncrementable - True
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - True
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - True
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - bigint
ProviderDbType - 0
ColumnSize - 19
CreateFormat - bigint
CreateParameters - 
DataType - System.Int64
IsAutoIncrementable - True
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - True
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - timestamp
ProviderDbType - 19
ColumnSize - 8
CreateFormat - timestamp
CreateParameters - 
DataType - System.Byte[]
IsAutoIncrementable - False
IsBestMatch - False
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - False
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - True
IsLiteralSupported - 
LiteralPrefix - 0x
LiteralSuffix - 
TypeName - binary
ProviderDbType - 1
ColumnSize - 8000
CreateFormat - binary({0})
CreateParameters - length
DataType - System.Byte[]
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 0x
LiteralSuffix - 
TypeName - image
ProviderDbType - 7
ColumnSize - 2147483647
CreateFormat - image
CreateParameters - 
DataType - System.Byte[]
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - True
IsNullable - True
IsSearchable - False
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 0x
LiteralSuffix - 
TypeName - text
ProviderDbType - 18
ColumnSize - 2147483647
CreateFormat - text
CreateParameters - 
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - True
IsNullable - True
IsSearchable - False
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - '
LiteralSuffix - '
TypeName - ntext
ProviderDbType - 11
ColumnSize - 1073741823
CreateFormat - ntext
CreateParameters - 
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - True
IsNullable - True
IsSearchable - False
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - N'
LiteralSuffix - '
TypeName - decimal
ProviderDbType - 5
ColumnSize - 38
CreateFormat - decimal({0}, {1})
CreateParameters - precision,scale
DataType - System.Decimal
IsAutoIncrementable - True
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 38
MinimumScale - 0
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - numeric
ProviderDbType - 5
ColumnSize - 38
CreateFormat - numeric({0}, {1})
CreateParameters - precision,scale
DataType - System.Decimal
IsAutoIncrementable - True
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - False
MaximumScale - 38
MinimumScale - 0
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 
LiteralSuffix - 
TypeName - datetime
ProviderDbType - 4
ColumnSize - 23
CreateFormat - datetime
CreateParameters - 
DataType - System.DateTime
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - {ts '
LiteralSuffix - '}
TypeName - smalldatetime
ProviderDbType - 15
ColumnSize - 16
CreateFormat - smalldatetime
CreateParameters - 
DataType - System.DateTime
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - {ts '
LiteralSuffix - '}
TypeName - sql_variant
ProviderDbType - 23
ColumnSize - 
CreateFormat - sql_variant
CreateParameters - 
DataType - System.Object
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - False
LiteralPrefix - 
LiteralSuffix - 
TypeName - xml
ProviderDbType - 25
ColumnSize - 2147483647
CreateFormat - xml
CreateParameters - 
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - False
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - True
IsNullable - True
IsSearchable - False
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - False
LiteralPrefix - 
LiteralSuffix - 
TypeName - varchar
ProviderDbType - 22
ColumnSize - 2147483647
CreateFormat - varchar({0})
CreateParameters - max length
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - '
LiteralSuffix - '
TypeName - char
ProviderDbType - 3
ColumnSize - 2147483647
CreateFormat - char({0})
CreateParameters - length
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - '
LiteralSuffix - '
TypeName - nchar
ProviderDbType - 10
ColumnSize - 1073741823
CreateFormat - nchar({0})
CreateParameters - length
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - N'
LiteralSuffix - '
TypeName - nvarchar
ProviderDbType - 12
ColumnSize - 1073741823
CreateFormat - nvarchar({0})
CreateParameters - max length
DataType - System.String
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - True
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - N'
LiteralSuffix - '
TypeName - varbinary
ProviderDbType - 21
ColumnSize - 1073741823
CreateFormat - varbinary({0})
CreateParameters - max length
DataType - System.Byte[]
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - False
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - 0x
LiteralSuffix - 
TypeName - uniqueidentifier
ProviderDbType - 14
ColumnSize - 16
CreateFormat - uniqueidentifier
CreateParameters - 
DataType - System.Guid
IsAutoIncrementable - False
IsBestMatch - True
IsCaseSensitive - False
IsFixedLength - True
IsFixedPrecisionScale - False
IsLong - False
IsNullable - True
IsSearchable - True
IsSearchableWithLike - False
IsUnsigned - 
MaximumScale - 
MinimumScale - 
IsConcurrencyType - False
IsLiteralSupported - 
LiteralPrefix - '
LiteralSuffix - '