BOOL, double precision, real, BOOLEAN = smallmoney, money TINYINT (1) SMALLINT (M) smallint M is the number of decimal tinyint, smallint, int, places in the output for this bigint, numeric(p,s), value. decimal(p,s), float(p), double precision, real, smallmoney, money MEDIUMINT (M) int M is the number of decimal tinyint, smallint, int, places in the output for this bigint, numeric(p,s), value. decimal(p,s), float(p), double precision, real, smallmoney, money INT (M) int M is the number of decimal tinyint, smallint, int, places in the output for this bigint, numeric(p,s), INTEGER (M) value. decimal(p,s), float(p), double precision, real, smallmoney, money BIGINT (M) M is the number of decimal bigint tinyint, smallint, int, places in the output for this bigint, numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money (P) float (P) None. numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money FLOAT [(P, S)] float (24) MySQL allows a numeric(p,s), nonstandard syntax: decimal(p,s), float(p), FLOAT(P,S) or REAL(P,S) double precision, real, or DOUBLE smallmoney, money PRECISION(P,S). Here, DOUBLE [(P, S)] (53) numeric(p,s), means that values “(P,S)” decimal(p,s), float(p), are displayed with up to P DOUBLE double precision, real, digits total, of which S PRECISION [(P, smallmoney, money digits may be after the S)] decimal point. MySQL performs rounding when REAL [(P, S)] storing values.
BOOL, BOOLEAN = TINYINT (1) double precision, real, smallmoney, money SMALLINT (M) smallint M is the number of decimal places in the output for this value. tinyint, smallint, int, bigint, numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money MEDIUMINT (M) int M is the number of decimal places in the output for this value. tinyint, smallint, int, bigint, numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money INT (M) INTEGER (M) int M is the number of decimal places in the output for this value. tinyint, smallint, int, bigint, numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money BIGINT (M) bigint M is the number of decimal places in the output for this tinyint, smallint, int, bigint, numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money (P) float (P) None. numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money FLOAT [(P, S)] float (24) MySQL allows a nonstandard syntax: FLOAT(P,S) or REAL(P,S) or DOUBLE PRECISION(P,S). Here, “(P,S)” means that values are displayed with up to P digits total, of which S digits may be after the decimal point. MySQL performs rounding when storing values. numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money DOUBLE [(P, S)] DOUBLE PRECISION [(P, S)] REAL [(P, S)] (53) numeric(p,s), decimal(p,s), float(p), double precision, real, smallmoney, money
MigrateMySQLtoSQLServer2008.docx