Specifies the type of command parameters.
public enum CmdParamsDbType : int
An extension of the ASCII character set in that it includes all the ASCII characters with an additional 128 character codes
fixed-length stream of non-Unicode characters.
System.Array of type System.Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
2 logical values, true and false
Allows whole numbers from 0 to 255
Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use
Date data ranging in value from January 1,1 AD through December 31, 9999 AD.
System.DateTime. Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
From January 1, 0001 to December 31, 9999 with an accuracy of 100 nanoseconds
Date and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00.
System.Decimal. A fixed precision and scale numeric value between -10 to -1 and 10 to -1.
Double precision floating-point. Will handle most decimals.
Stores a globally unique identifier.
A 16-bit signed integer.
A 32-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647
A 64-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647
Can store pictures, audio, video, or other BLOBs (Binary Large OBjects)
Single precision floating-point. Will handle most decimals Allows whole numbers from -128 to 127
Used for string datatypes
A fixed-length string of Unicode characters.
Time data based on a 24-hour clock. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.
A 32-bit un-signed integer. Allows whole numbers from 0 to 65535
A 32-bit un-signed integer. Allows whole numbers from 0 to 4294967295
A 64-bit un-signed integer. Allows whole numbers from 0 to 18446744073709551615
A variable-length numeric value.
A SQL Server 2005 user-defined type (UDT). Stores XML formatted data. Maximum 2GB