sql server2005ÖÐÊý¾ÝÀàÐ͵ÄNumeric(18,0) ÊÇʲôÒâ˼?

ÒѾٱ¨ »Ø´ð
sql server2005ÖÐÊý¾ÝÀàÐ͵ÄNumeric(18,0) ÊÇʲôÒâ˼?
ÎÊÔÚÏß¿Í·þ
ɨÂëÎÊÔÚÏß¿Í·þ
  • »Ø´ðÊý

    5

  • ä¯ÀÀÊý

    8,543

5¸ö»Ø´ð ĬÈÏÅÅÐò
  • ĬÈÏÅÅÐò
  • °´Ê±¼äÅÅÐò

ÒѲÉÄÉ
¸úÄã×ö¸öÀý×Ó°É¡£
SQL create table testbb (column1 Numeric(18,0),column2 Numeric(18,1),column3 Numeric(18,2));

Table created
SQL insert into testbb values(123456.11,123456.11,123456.11);

1 row inserted

SQL select * from testbb;

COLUMN1 COLUMN2 COLUMN3
------------------- -------------------- --------------------
123456 123456.1 123456.11

SQL

´ÓÉÏÃæµÄÀý×ÓÄã¿´³öÀ´Ã»
Numeric(18,0)ÊÇÒ»¸öÊý¾ÝÀàÐÍ£¬ÆäÖÐ18±íʾÓÐЧÊý×Ö룬0±íʾСÊýµãºóÃæµÄλÊý
È¡Ïû ÆÀÂÛ
select * from
È¡Ïû ÆÀÂÛ
³öÏÖÕâ¸öÎÊÌâÒ»°ãÓÐÈýÖÖÇé¿ö£º
1.ÄãµÄÊý¾Ý¿âÕýÔÚÕ¼Óã¬
2.ÄãµÄ±¸·ÝÎļþÌ«´ó
3.Äã´æ´¢±¸·ÝÎļþµÄÓ²ÅÌÕýæ

ÎҸоõÄãµÄÊý¾Ý¿âÏñÊÇÔÚÕ¼Óã¬Ò»°ãÁ¬½ÓÊý¾Ý¿âµÄ³ÌÐò£¬»òÊÇ¿ª·¢»·¾³´ò¿ª×ÅÒ²»áµ¼ÖÂÊý¾Ý¿âÕ¼Ó᣽¨ÒéÏÈ·ÖÀë»òɾ³ýÔ­Êý¾Ý¿âÔÙ»¹Ô­£¬ÒòΪ·ÖÀëºÍɾ³ýÓÐÇ¿ÖƹرÕÁ¬½Ó
È¡Ïû ÆÀÂÛ
Numeric(18,0) Ö¸×Ö¶ÎÊÇÊý×ÖÐÍ,³¤¶ÈΪ18 СÊýΪ0λµÄ
È¡Ïû ÆÀÂÛ
Numeric ºÍdecimal ÊÇÒ»ÑùµÄ£¬¶¼ÊÇÊýÖµÀàÐÍ.
Ç°ÃæµÄ18´ú±íÓÐЧλÊý,º¬Ð¡ÊýµãÇ°ÃæºÍááÃæµÄλÊý
ááÃæµÄ0´ú±íСÊýλÊý
È¡Ïû ÆÀÂÛ
ZOLÎÊ´ð > Ïà»ú > ÆäËû > sql server2005ÖÐÊý¾ÝÀàÐ͵ÄNumeric(18,0) ÊÇʲôÒâ˼?

¾Ù±¨

¸ÐлÄúΪÉçÇøµÄºÍг¹±Ï×Á¦Á¿ÇëÑ¡Ôñ¾Ù±¨ÀàÐÍ

¾Ù±¨³É¹¦

¾­¹ýºËʵºó½«»á×ö³ö´¦Àí
¸ÐлÄúΪÉçÇøºÍг×ö³ö¹±Ï×

ɨÂë²ÎÓëÐÂÆ·0ÔªÊÔÓÃ
ɹµ¥¡¢¶¥Â¥ºÀÀñµÈÄãÄÃ

ɨһɨ£¬¹Ø×¢ÎÒÃÇ
Ìáʾ

È·¶¨ÒªÈ¡Ïû´Ë´Î±¨Ãû£¬Í˳ö¸Ã»î¶¯£¿