????int??bigint??smallint ?? tinyint
????????????????????????????????
????bigint
?????? -2^63 (-9223372036854775808) ?? 2^63-1 (9223372036854775807) ???????????????????????洢??С? 8 ???????
????int
?????? -2^31 (-2??147??483??648) ?? 2^31 - 1 (2??147??483??647) ???????????????????????洢??С? 4 ??????int ?? SQL-92 ?????? integer??
????smallint
?????? -2^15 (-32??768) ?? 2^15 - 1 (32??767) ????????????洢??С? 2 ??????
????tinyint
?????? 0 ?? 255 ????????????洢??С? 1 ????
???????
????????????????????? bigint ??????????????bigint ?????Щ????????????????????? int ?????????????Χ?????????? bigint???? SQL Server ?У?int ????????????????????????????
????1. char
??????????????n???????
????2. varchar
?????????n???????????
??????n?????????????????????n?????
????char??varchar????
????varchar??char??????????Ч?????char??????Щ??
?????varchar??char???????????varchar??????????????磺??varchar(5)?洢?????“abc”??????3??????洢???????char(5)?洢???????5??????“abc  ”????
?????varchar??charЧ?????????????????varchar?????????????????????????????????????????????I/O???????У?oracle??????I/O???????????“?????”??Row Migration????
???????????????????????У?bigint λ?? smallmoney ?? int ???
??????е??????????? bigint ???????????????????? bigint??SQL Server ??????????????????????????tinyint??smallint ?? int??????? bigint??
?????????1?????
????????1?????
????????????2?????