VBÈçºÎÉùÃ÷Êý×Ö±äÁ¿ - VB / »ù´¡Àà
ÎÒÓÐÒ»¸öÊý×ÖÊÇ´ÓÊý¾Ý¿âÀïÃæÈ¡³öµÄ£¬¸ÃÊý¾Ý¿âµÄ×Ö¶ÎÊý×ÖÀàÐÍÊÇdecimal 13,ÖÁÉÙÒª±£Áô4λСÊý
,ÎÒ´ÓÕâ¸ö×Ö¶ÎÈ¡µ½ÊýºóÒª¸³¸øÒ»¸ö±äÁ¿fquantity£¬Õâ¸ö±äÁ¿ÎÒÉè³Ésingle(dim fquantity as single),µ«ÊÇ·¢ÏÖÓеÄʱºòÕâ¸öÊý±¾À´ÊÇ0µÄ£¬´«µÝµ½ºóÃæµÄʱºòÈ´±ä³ÉÁËÒ»¸öĪÃûÆæÃîµÄÊý×Ö£¬ÎÒ¾õµÃºÜÆæ¹Ö£¬ÎÒ¹À¼ÆÊÇÎÒµÄÉêÃ÷´íÁË¡£ÄÇôӦ¸ÃÈçºÎÉùÃ÷ÄØ£¿»¹ÓоÍÊǽð¶î£¬Ó¦¸ÃÈçºÎÉùÃ÷£¿Âé·³ÎÊһϴó¼Ò¡£
decimal 13£¿
ÊÇʲôÊý¾Ý¿â£¿
£¨µ«ÊÇ·¢ÏÖÓеÄʱºòÕâ¸öÊý±¾À´ÊÇ0µÄ£¬´«µÝµ½ºóÃæµÄʱºòÈ´±ä³ÉÁËÒ»¸öĪÃûÆæÃîµÄÊý×Ö£©
ÉÏ´úÂë¿´¿´
SQL SERVER
CREATE TABLE [dbo].[m_QuantityBalance] (
[MYear] [int] NOT NULL ,
[MPeriod] [int] NOT NULL ,
[FQuantity] [decimal](23, 10) NULL ,
[MMoney] [MONEY] NULL
) ON [PRIMARY]
GO
Ìù³ö´úÂë¾ÍÖªµÀÁË¡£Êý¾Ý¿âµÄ¶¨Òå³öÌù³öÀ´¡£
ÉùÃ÷´øÐ¡ÊýµãµÄÊý×Ö´ó¼Òƽʱ¶¼ÉêÃ÷³ÉʲôÀàÐÍÄØ?
Äã˵single²»ÐÐ,ÄÇdoubleÄØ
doubleûÓÐÊÔ¹ý£¬ÄÇΪʲôsingle²»ÐÐÄØ£¿ºÜÆæ¹Ö
¿ÉÄܾ«¶È²»¹»°É,»¹ÓÐDecimalÒ²¿ÉÊÔÏÂ, Õâ·½ÃæÃ»É¶¾Ñé,¾Í²»¶à²ÂÁË
[FQuantity] [decimal](23, 10) NULL ,
´ÓÒÔÉÏ¿´³öFQuantity×Ö¶ÎΪdecimalÀàÐÍ£¬ÕûÊý²¿·Ö³¤¶È13λ£¬Ð¡Êý²¿·Ö³¤¶È10룬×ܳ¤¶È23λ¡£
sql serverµÄ
decimal Êý¾ÝÀàÐÍ×î¶à¿É´æ´¢ 38 ¸öÊý×Ö£¬ËùÓÐÊý×Ö¶¼Äܹ»·Åµ½Ð¡ÊýµãµÄÓұߡ£decimal Êý¾ÝÀàÐÍ´æ´¢ÁËÒ»¸öÈ·¶¨µÄÊý×Ö±í´ï·¨£»Ã»Óд洢ֵµÄ½üËÆÖµ¡£
vb6µÄ
µ¥¾«¶È±äÁ¿×ܳ¤¶È8루º¬Ð¡Êýµã£©£¬Èç8.123456¡¢8123.456
Ë«¾«¶È±äÁ¿×ܳ¤¶È16루º¬Ð¡Êýµã£©£¬Èç1234567890123.45¡¢1234567890.12345
°ÑËü·ÅÈëÎÞÂÛÊǵ¥¾«¶È±äÁ¿»
Ïà¹ØÎÊ´ð£º
Ϊʲô¹¤¾ßÀ¸°´Å¤µÄ¿í¶È¸Ä±ä²»ÁË,ÔÚÊôÐÔÀï¸ÄÁËÓÖ±ä³ÉÔÀ´µÄÊýÖµÁË
´óºú×ÓÕæÀ÷º¦£¬»Ø´ð»ù±¾¶¼ÊDZ¬Áϼ¶µÄ
´óºú×ÓÉý¼¶Õæ¿ì°¡£¬Õâ²Å¼¸Ìì¾Í5Ìõ¶Ì¿ãÍâ¼ÓÔÂÅÅÃûµÚÒ»ÁË
ÏëÏëÎÒÕâ5¸ö¶Ì¿ã»ìÁ˲¶à8Äê²ÅµÃµ½µÄ¡£
»Ø¸´ ......
ΪʲôÎÒÏëÑ»·×Ô¶¯·¢ËÍÓʼþµÄʱºò,¾ÍÖ»ÓеÚÒ»·âÄÜ×Ô¶¯·¢ËÍ,ÆäËüºóÃæµÄÓʼþ¶¼Ö»ÄÜ´´½¨,²»ÄÜ×Ô¶¯·¢ËÍ
Private Sub send_mail_Click() '·¢ËÍÓʼþ֪ͨ
Do While Not TDBG_Dept.EOF
If A> ......
ÔÚÍøÉÏÏÂÔØÁËspeechsdk51LangPack°²×°ºó£¬ÓÃvb¿ÉÒÔ·¢Òô£¨ÖÐÎÄ£©£¬ÀïÃæÓиögirl xiaokunµÄ·¢Òô£¬¶ÔÖÐÎĺܺÃÌý¡£µ«ÊÇÕâ¸öspeechsdk51LangPackÓÐ100¶àM£¬ÎÒµÄvbÏîÄ¿´ò°üºó£¬Ôõô²Å¿ÉÒÔ×°µ½ÆäËû»ú×ÓÉÏÒ²ÄÜÓã¿£¿×ܲ»ÄÜÿ ......
Private Sub btnPrint_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnPrint.Click
MouseWait()
Dim ClearTempTabelSQL As String
'If Not ......
°ÑÒÑÓÐÊý¾Ý£¨Êý¾Ý´óÓÚ20ÐУ©µÄRS(recordset)µÄµÚ10ÐÐÊý¾ÝÓëµÚ11ÐÐÊý¾Ý×ö¼Ó·¨ºó£¬É¾³ýµÚ11ÐеÄÊý¾Ý£¬È»ºó°ÑºóÃæµÄÊý¾ÝÏòÇ°ÒÆ¡£
RSµÄ»°ÐÞ¸ÄÊý¾ÝÊÇ»á¸üÐÂÊý¾Ý¿â£¬ÏÖÔÚµÄÎÊÌâÊÇRSÀïµÄÒÑÓÐÊý¾ÝÊÇÓÃSQLÓï¾ä·ÖÀàͳ¼Æ³öÀ´µÄ ......