If M and D are omitted, values are stored up to the size limits allowed by the hardware. DECIMAL [(P [, decimal [(P [, Decimal types can have up numeric(p,s), S])] S])] to 65 digits. For a decimal decimal(p,s), float(p), with a precision of more double precision, real, DEC [(P [, S])] numeric [(P [, than 38, use the float or smallmoney, money S])] double data type. NUMERIC [(P [, S])] FIXED [(P [, S])] DATETIME [(D)] datetime2 MySQL can store dates smalldatetime, from 0000-00-00 to datetime, datetime2 MySQL can store DATE [(D)] date smalldatetime, zero-value of year, month, datetime, datetime2, and year. date TIME time Range is '-838:59:59' to smalldatetime, '838:59:59'. datetime, datetime2, time, varchar, nvarchar TIMESTAMP smalldatetime Range is '1970-01-01 datetime, datetime2, 00:00:00' to partway rowversion, through the year 2037. If timestamp, not defined during varbinary(8), binary(8) conversion, this type gets the current datetime value. YEAR [(2| 4)] smallint In four-digit format, datetime, date, allowable values are 1901 varchar(4) to 2155, and 0000. In format, allowable values are 70 to 69, representing years from 1970 to 2069. [NATIONAL] (N) Range of N is 0 to 255 CHAR (N) characters.
If M and D are omitted, values are stored up to the size limits allowed by the hardware. DECIMAL [(P [, S])] DEC [(P [, S])] NUMERIC [(P [, S])] FIXED [(P [, S])] decimal [(P [, S])] numeric [(P [, S])] Decimal types can have up to 65 digits. For a decimal with a precision of more than 38, use the float or double data type. numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money DATETIME [(D)] datetime2 MySQL can store dates from 0000-00-00 to MySQL can store zero-value of year, month, and year. smalldatetime, datetime, datetime2 DATE [(D)] date smalldatetime, datetime, datetime2, date TIME time Range is '-838:59:59' to '838:59:59'. smalldatetime, datetime, datetime2, time, varchar, nvarchar TIMESTAMP smalldatetime Range is '1970-01-01 00:00:00' to partway through the year 2037. If not defined during conversion, this type gets the current datetime value. datetime, datetime2, rowversion, timestamp, varbinary(8), binary(8) YEAR [(2| 4)] smallint In four-digit format, allowable values are 1901 to 2155, and 0000. In format, allowable values are 70 to 69, representing years from 1970 to 2069. datetime, date, varchar(4) [NATIONAL] CHAR (N) (N) Range of N is 0 to 255 characters.
MigrateMySQLtoSQLServer2008.docx