Because the value of double is relatively large, it may overflow when converted into integer, so we should pay attention to this problem in actual processing.

CONVERT(int, field or variable)?

CONVERT(bigint, field or variable)

NT and BIGINT are compatible, but the difference is that they occupy different space on the disk, and the range of numbers they can represent is different, which should have no influence on the existing data query and display programs.