| SQLTutorials | |
| Powered By PhICK1.com | |
SQL Server DataTypebigint Integer data from -2^63 through 2^63-1 binary Fixed-length binary data with a maximum length of 8,000 bytes bit Integer data with either a 1 or 0 value char Fixed-length character data with a maximum length of 8,000 characters datetime Date and time data from January 1, 1753, through December 31, 9999,with an accuracy of 3.33 milliseconds decimal Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1 float Floating precision number data from -1.79E + 308 through 1.79E + 308 image Variable-length binary data with a maximum length of 2^31 - 1 bytes int Integer data from -2^31 through 2^31 - 1 money Monetary data values from -2^63 through 2^63 - 1 nchar Fixed-length Unicode data with a maximum length of 4,000 characters ntext Variable-length Unicode data with a maximum length of 2^30 - 1 characters nvarchar Variable-length Unicode data with a maximum length of 4,000 characters numeric Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1 real Floating precision number data from -3.40E + 38 through 3.40E + 38 smalldatetime Date and time data from January 1, 1900, through June 6, 2079,with an accuracy of one minute smallint Integer data from -2^15 through 2^15 - 1 smallmoney Monetary data values from -214,748.3648 through +214,748.3647 sysname text Variable-length data with a maximum length of 2^31 - 1 characters timestamp tinyint Integer data from 0 through 255 varbinary Variable-length binary data with a maximum length of 8,000 bytes varchar Variable-length data with a maximum of 8,000 characters uniqueidentifier A globally unique identifier powered by www.pHick1.com |
|