尊龙凯时人生就是博

sqlÖÐСÊýÔõôÌåÏÖ

ÔÚ sql ÖÐ £¬Ð¡Êýͨ³£Ê¹Óà decimal »ò numeric Êý¾ÝÀàÐÍÌåÏÖ¡£decimal ÓÃÓÚÌåÏÖÀο¿¾«¶ÈºÍСÊýλÊýµÄСÊý £¬¶ø numeric ÔÊÔÊÐí±ä¾«¶ÈºÍСÊýλÊý¡£Ñ¡ÔñºÏÊʵÄÀàÐÍÈ¡¾öÓÚËùÐèСÊýµÄ¾«¶ÈºÍ¿É±äÐÔ¡£

SQL ÖÐСÊýµÄÌåÏÖ

ÔÚ SQL ÖÐ £¬Ð¡Êýͨ³£ÓÉ DECIMAL »ò NUMERIC Êý¾ÝÀàÐÍÌåÏÖ¡£

DECIMAL

DECIMAL Êý¾ÝÀàÐÍÓÃÓÚÌåÏÖÀο¿¾«¶ÈºÍСÊýλÊýµÄСÊý¡£¾«¶ÈÊÇÖ¸Êý×ÖµÄ×ÜλÊý£¨°üÀ¨Ð¡Êýµã£© £¬Ð¡ÊýλÊýÊÇָСÊýµãÓÒ²àµÄλÊý¡£

ÀýÈ磺

DECIMAL(5,2)

µÇ¼ºó¸´ÖÆ

ÌåÏÖÒ»¸ö³¤¶ÈΪ 5 λ £¬Ð¡ÊýλÊýΪ 2 λµÄСÊý¡£

NUMERIC

NUMERIC Êý¾ÝÀàÐÍÓë DECIMAL ÀàËÆ £¬µ«ÔÊÔÊÐí±ä¾«¶ÈºÍСÊýλÊý¡£ÕâÒâζ×ÅСÊýµÄ³¤¶ÈºÍ¾«¶È¿ÉÒÔÔÚÊý¾Ý²åÈëʱ¶¯Ì¬µ÷½â¡£

ÀýÈ磺

NUMERIC(5,2)

µÇ¼ºó¸´ÖÆ

ÌåÏÖÒ»¸öСÊý £¬¾«¶ÈΪ 5 λ £¬Ð¡ÊýλÊýΪ 2 λ¡£¿ÉÊÇ £¬ÔÚ²åÈëÊý¾Ýʱ £¬Ð¡Êý¿ÉÒÔ¾ßÓвî±ðµÄ¾«¶ÈºÍСÊýλÊý £¬Ö»Òª²»Áè¼ÝÖ¸¶¨µÄÏÞÖÆ¡£

Ñ¡ÔñºÏÊʵÄÀàÐÍ

Ñ¡Ôñ DECIMAL »ò NUMERIC Êý¾ÝÀàÐÍÈ¡¾öÓÚËùÐèµÄСÊýµÄ¾«¶ÈºÍ¿É±äÐÔ¡£¹ØÓÚÀο¿¾«¶ÈºÍСÊýλÊýµÄСÊý £¬Ê¹Óà DECIMAL¡£¹ØÓÚ¾«¶ÈºÍ¿É±äСÊýλÊýµÄСÊý £¬Ê¹Óà NUMERIC¡£

ÒÔÉϾÍÊÇsqlÖÐСÊýÔõôÌåÏÖµÄÏêϸÄÚÈÝ £¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí £¬°æȨÕùÒéÓë±¾Õ¾ÎÞ¹Ø £¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是博ÂËÓÍ»úÍø¹Ù·½Ì¬¶È £¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ £¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢ £¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢ £¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是博ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ尊龙凯时人生就是博

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎå £¬9:30-18:30 £¬½ÚãåÈÕÐÝÏ¢

QR code
sitemap¡¢ÍøÕ¾µØͼ