MS SQL Server 2005 ¤Îint,money,bit¤Ë¤Ä¤¤¤Æ¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
- ¤³¤Î¥Õ¥©¡¼¥é¥à¤Ë¿·¤·¤¤¥È¥Ô¥Ã¥¯¤òΩ¤Æ¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó
- ¤³¤Î¥Õ¥©¡¼¥é¥à¤Ç¤Ï¥²¥¹¥ÈÅê¹Æ¤¬¶Ø»ß¤µ¤ì¤Æ¤¤¤Þ¤¹
hitachijoho
Åê¹Æ¿ô: 53
![¾ïÏ¢ ¾ïÏ¢](../../uploads/rank3dbf8e9e7d88d.gif)
¤¤¤Ä¤â¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹¡£
¤´Ä󼨤ÎVal´Ø¿ô¤Î»È¤¤Êý¤Ë¤è¤ê¡¢º£²ó¤ÎÌäÂê¤ò²ò·è¤·¤Þ¤·¤¿¡£
À¿¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
º£¸å¤È¤â¤´»ØƳ¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¤´Ä󼨤ÎVal´Ø¿ô¤Î»È¤¤Êý¤Ë¤è¤ê¡¢º£²ó¤ÎÌäÂê¤ò²ò·è¤·¤Þ¤·¤¿¡£
À¿¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
º£¸å¤È¤â¤´»ØƳ¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Jiro123
Åê¹Æ¿ô: 271
![ĹϷ ĹϷ](../../uploads/rank3dbf8eb1a72e7.gif)
¤¹¤ß¤Þ¤»¤ó¡£Excel¥³¥ó¥Ý¡¼¥Í¥ó¥È¤ÇCell¥á¥½¥Ã¥É¤Ç¼èÆÀ¤·¤¿¥Ç¡¼¥¿¤Ïʸ»ú·¿¤Ç¤·¤¿¤Í¡£
¤½¤³¤Þ¤ÇƬ¤¬²ó¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£¤½¤ì¤Ê¤é¤ÐÊÑ´¹¤ÏɬÍפǤ¹¤Í¡£
¿ôÃÍʸ»úÎó¤ò¿ôÃÍ·¿¤ËÊÑ´¹¤¹¤ë¤Ë¤Ï¡¢Val´Ø¿ô¤ò»È¤¤¤Þ¤¹¡£
¤´Ä󼨤ÎVal´Ø¿ô¤Î»È¤¤Êý¤Ï¡¢Val´Ø¿ô¤Î½ñ¼°¤Î¤È¤³¤í¤¬´Ö°ã¤Ã¤Æ¤¤¤Þ¤¹¡£
Éé¿ô¥Ç¡¼¥¿¤Î¾ì¹ç¤Î½ñ¼°¤Ë¤Ï¡ÖN¡×¤¬É¬Íפˤʤê¤Þ¤¹¡£
Î㤨¤Ð¡¢¥Õ¥í¡¼ÊÑ¿ô¡ÖF.String1(ʸ»ú·¿)¡×¤Î½ñ¼°¤¬3¤À¤È¤¹¤ë¤È¡¢-99¤«¤é999¤Þ¤Ç¤Î¿ôÃÍʸ»úÎ󤬳ÊǼ¤Ç¤¤Þ¤¹¤è¤Í¡£
¤³¤Î¥Õ¥í¡¼ÊÑ¿ô¤ò¿ôÃÍ·¿¤ËÊÑ´¹¤¹¤ë¤Ë¤Ï¡¢
Val(F.String1,'N3')¡¢¤Þ¤¿¤Ï¡¢
Val(F.String1,'N###')¡¢¤Þ¤¿¤Ï¡¢
Val(F.String1,'N#3')
¤Èµ½Ò¤·¤Þ¤¹¡£
¿ôÃÍ·¿¤Ç½ñ¼°¤¬N3¤À¤È¡¢¿ôÃͥǡ¼¥¿¤Î͸úÈϰϤÏ-999¤«¤é999¤Ë¤Ê¤ë¤Î¤Ç¤¹¤¬¡¢¿ôÃÍʸ»úÎó¤Î¾ì¹ç¤Ï¡¢¥Þ¥¤¥Ê¥¹µ¹æ¤â1¥Ð¥¤¥È¤Îʸ»ú¤È¤Ê¤ê¤Þ¤¹¡£
¿ôÃÍʸ»úÎó¤Î¿ôÃͤȤ·¤Æ¤Î͸úÈϰϤò¹Íθ¤·¤Æ¡¢Val´Ø¿ô¤Î½ñ¼°¤ò»ØÄꤷ¤Þ¤¹¡£
ʸ»ú·¿¤Î½ñ¼°¤¬3¤Î¾ì¹ç¤Ï¡¢¾å½Ò¤ÎÄ̤ꡢ¿ôÃÍʸ»úÎó¤È¤·¤Æ¤Ï¡¢-99¤«¤é999¤¬Í¸úÈϰϤȤʤꡢÀ°¿ô¤À¤È3·å¤Þ¤Ç͸ú¤Ë¤Ê¤ë¤Î¤Ç¡¢Val´Ø¿ô¤Î½ñ¼°¤Ï¡Ö'N3'¡×¤È¤Ê¤ê¤Þ¤¹¡£
Äê¿ô¡Ö'-1'¡×¤Î¾ì¹ç¤Ï¡¢Äê¿ô¤Î¿ôÃÍʸ»úÎó¤Î¿ôÃͤȤ·¤Æ¤Î͸úÈϰϤò¹Íθ¤·¤Æ¡¢½ñ¼°¤ò»ØÄꤹ¤ë¤È¡¢
Val('-1','N1')¡¢¤Þ¤¿¤Ï¡¢
Val('-1','N#')¡¢
¤Èµ½Ò¤Ç¤¤Þ¤¹¡£
Val('-1','N#1')¤Èµ½Ò¤·¤Æ¤â¤è¤¤¤Ç¤¹¤¬¡¢¤³¤Î¤è¤¦¤Ê½ñ¼°¤Îµ½Ò¤Ï¤¢¤Þ¤ê¤·¤Ê¤¤¤Ç¤¹¤Í¡£
jBOLT¤Î´Ø¿ô¤Îµ½Ò¤Ï¡¢Magic uniPaaS¤Î´Ø¿ô¤ÈƱ¤¸¤Ç¤¹¡£
Magic uniPaaS¤òÃΤäƤ¤¤ë¤È¡¢jBOLT¤Ç¤Î´Ø¿ô¤Îµ½Ò¤¬Íưפˤʤê¤Þ¤¹¡£
¤´»²¹Í¤¯¤À¤µ¤¤¡£
¤½¤³¤Þ¤ÇƬ¤¬²ó¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£¤½¤ì¤Ê¤é¤ÐÊÑ´¹¤ÏɬÍפǤ¹¤Í¡£
¿ôÃÍʸ»úÎó¤ò¿ôÃÍ·¿¤ËÊÑ´¹¤¹¤ë¤Ë¤Ï¡¢Val´Ø¿ô¤ò»È¤¤¤Þ¤¹¡£
¤´Ä󼨤ÎVal´Ø¿ô¤Î»È¤¤Êý¤Ï¡¢Val´Ø¿ô¤Î½ñ¼°¤Î¤È¤³¤í¤¬´Ö°ã¤Ã¤Æ¤¤¤Þ¤¹¡£
Éé¿ô¥Ç¡¼¥¿¤Î¾ì¹ç¤Î½ñ¼°¤Ë¤Ï¡ÖN¡×¤¬É¬Íפˤʤê¤Þ¤¹¡£
Î㤨¤Ð¡¢¥Õ¥í¡¼ÊÑ¿ô¡ÖF.String1(ʸ»ú·¿)¡×¤Î½ñ¼°¤¬3¤À¤È¤¹¤ë¤È¡¢-99¤«¤é999¤Þ¤Ç¤Î¿ôÃÍʸ»úÎ󤬳ÊǼ¤Ç¤¤Þ¤¹¤è¤Í¡£
¤³¤Î¥Õ¥í¡¼ÊÑ¿ô¤ò¿ôÃÍ·¿¤ËÊÑ´¹¤¹¤ë¤Ë¤Ï¡¢
Val(F.String1,'N3')¡¢¤Þ¤¿¤Ï¡¢
Val(F.String1,'N###')¡¢¤Þ¤¿¤Ï¡¢
Val(F.String1,'N#3')
¤Èµ½Ò¤·¤Þ¤¹¡£
¿ôÃÍ·¿¤Ç½ñ¼°¤¬N3¤À¤È¡¢¿ôÃͥǡ¼¥¿¤Î͸úÈϰϤÏ-999¤«¤é999¤Ë¤Ê¤ë¤Î¤Ç¤¹¤¬¡¢¿ôÃÍʸ»úÎó¤Î¾ì¹ç¤Ï¡¢¥Þ¥¤¥Ê¥¹µ¹æ¤â1¥Ð¥¤¥È¤Îʸ»ú¤È¤Ê¤ê¤Þ¤¹¡£
¿ôÃÍʸ»úÎó¤Î¿ôÃͤȤ·¤Æ¤Î͸úÈϰϤò¹Íθ¤·¤Æ¡¢Val´Ø¿ô¤Î½ñ¼°¤ò»ØÄꤷ¤Þ¤¹¡£
ʸ»ú·¿¤Î½ñ¼°¤¬3¤Î¾ì¹ç¤Ï¡¢¾å½Ò¤ÎÄ̤ꡢ¿ôÃÍʸ»úÎó¤È¤·¤Æ¤Ï¡¢-99¤«¤é999¤¬Í¸úÈϰϤȤʤꡢÀ°¿ô¤À¤È3·å¤Þ¤Ç͸ú¤Ë¤Ê¤ë¤Î¤Ç¡¢Val´Ø¿ô¤Î½ñ¼°¤Ï¡Ö'N3'¡×¤È¤Ê¤ê¤Þ¤¹¡£
Äê¿ô¡Ö'-1'¡×¤Î¾ì¹ç¤Ï¡¢Äê¿ô¤Î¿ôÃÍʸ»úÎó¤Î¿ôÃͤȤ·¤Æ¤Î͸úÈϰϤò¹Íθ¤·¤Æ¡¢½ñ¼°¤ò»ØÄꤹ¤ë¤È¡¢
Val('-1','N1')¡¢¤Þ¤¿¤Ï¡¢
Val('-1','N#')¡¢
¤Èµ½Ò¤Ç¤¤Þ¤¹¡£
Val('-1','N#1')¤Èµ½Ò¤·¤Æ¤â¤è¤¤¤Ç¤¹¤¬¡¢¤³¤Î¤è¤¦¤Ê½ñ¼°¤Îµ½Ò¤Ï¤¢¤Þ¤ê¤·¤Ê¤¤¤Ç¤¹¤Í¡£
jBOLT¤Î´Ø¿ô¤Îµ½Ò¤Ï¡¢Magic uniPaaS¤Î´Ø¿ô¤ÈƱ¤¸¤Ç¤¹¡£
Magic uniPaaS¤òÃΤäƤ¤¤ë¤È¡¢jBOLT¤Ç¤Î´Ø¿ô¤Îµ½Ò¤¬Íưפˤʤê¤Þ¤¹¡£
¤´»²¹Í¤¯¤À¤µ¤¤¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
hitachijoho
Åê¹Æ¿ô: 53
![¾ïÏ¢ ¾ïÏ¢](../../uploads/rank3dbf8e9e7d88d.gif)
Jiro123¤µ¤Þ
¡¡¤´²óÅú¡¢À¿¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
¡¡º£¡¢ÌäÂê¤Ë¤Ê¤Ã¤Æ¤¤¤ë½ê¤ÏExcel¥³¥ó¥Ý¡¼¥Í¥ó¥È¤Çcell¡Ö-1¡×¤ò¸Æ¤Ó½Ð¤·¤¿ÆâÍƤΥ¿¥¤¥×¤ÏAlpa¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¡¡¥Þ¥Ã¥×²èÌ̤ˤÆÁ÷¤êÀè¤Î¹àÌܤΥץí¥Ñ¥Æ¥£¤Î·×»»ÃÍÍó¤Ë¤Æ´Ø¿ô¤ò»È¤Ã¤ÆÊÑ´¹¤·¤Ê¤¤¤ÈÁ÷¤êÀè¤Î¹àÌܤΥץí¥Ñ¥Æ¥£¡Êint¡Ë¤È²ñ¤ï¤Ê¤¤¤Î¤Ç¡¢Build¤Ç¤¤Þ¤»¤ó¡£
¡¡·×»»ÃÍÍó¤Ë¤Æ´Ø¿ôVal('-1','-#')¤ò¤ä¤Ã¤Æ¸«¤Þ¤·¤¿¤¬¡¢
°Ü¹ÔÀè(MS SQL Server 2005)¤Ï¡Ö1¡×¤È¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£¡Ö-1¡×¤Ë¤Ê¤ë¤Ù¤¤Ç¤¹¤¬¡£¡£
¡¡Val('-1','-#')¤Î½ñ¤Êý¤ÏÉÔŬ¤Ç¤·¤ç¤¦¤«¡©
¡¡¤½¤ì¤È¤â¡¢Ê̤ÎÊÑ´¹´Ø¿ô¤ò»È¤¦¤Ç¤·¤ç¤¦¤«¡©
¤Ê¤ª¡¢
¡¡¡¡NUL¤Ë¤Ä¤¤¤Æ¤ÎÃí°ÕÅÀ¤òĺ¤¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
¡¡¡¡º£¸å¡¢Ãí°ÕÃפ·¤Þ¤¹¡£
°Ê¾å¡¢¤ª¼ê¿ô¤Ç¤¹¤¬¡¢¤´²óÅú¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¡¡¤´²óÅú¡¢À¿¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
¡¡º£¡¢ÌäÂê¤Ë¤Ê¤Ã¤Æ¤¤¤ë½ê¤ÏExcel¥³¥ó¥Ý¡¼¥Í¥ó¥È¤Çcell¡Ö-1¡×¤ò¸Æ¤Ó½Ð¤·¤¿ÆâÍƤΥ¿¥¤¥×¤ÏAlpa¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¡¡¥Þ¥Ã¥×²èÌ̤ˤÆÁ÷¤êÀè¤Î¹àÌܤΥץí¥Ñ¥Æ¥£¤Î·×»»ÃÍÍó¤Ë¤Æ´Ø¿ô¤ò»È¤Ã¤ÆÊÑ´¹¤·¤Ê¤¤¤ÈÁ÷¤êÀè¤Î¹àÌܤΥץí¥Ñ¥Æ¥£¡Êint¡Ë¤È²ñ¤ï¤Ê¤¤¤Î¤Ç¡¢Build¤Ç¤¤Þ¤»¤ó¡£
¡¡·×»»ÃÍÍó¤Ë¤Æ´Ø¿ôVal('-1','-#')¤ò¤ä¤Ã¤Æ¸«¤Þ¤·¤¿¤¬¡¢
°Ü¹ÔÀè(MS SQL Server 2005)¤Ï¡Ö1¡×¤È¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£¡Ö-1¡×¤Ë¤Ê¤ë¤Ù¤¤Ç¤¹¤¬¡£¡£
¡¡Val('-1','-#')¤Î½ñ¤Êý¤ÏÉÔŬ¤Ç¤·¤ç¤¦¤«¡©
¡¡¤½¤ì¤È¤â¡¢Ê̤ÎÊÑ´¹´Ø¿ô¤ò»È¤¦¤Ç¤·¤ç¤¦¤«¡©
¤Ê¤ª¡¢
¡¡¡¡NUL¤Ë¤Ä¤¤¤Æ¤ÎÃí°ÕÅÀ¤òĺ¤¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
¡¡¡¡º£¸å¡¢Ãí°ÕÃפ·¤Þ¤¹¡£
°Ê¾å¡¢¤ª¼ê¿ô¤Ç¤¹¤¬¡¢¤´²óÅú¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Jiro123
Åê¹Æ¿ô: 271
![ĹϷ ĹϷ](../../uploads/rank3dbf8eb1a72e7.gif)
°ÊÁ°¤Ë»î¤·¤¿»þ¤Î¤³¤È¤ò»×¤¤½Ð¤·¤Ê¤¬¤é½ñ¤¤¤Æ¤¤¤Þ¤¹¡£
jBOLTÆâÉô¤Ç¤Ï¡¢
int¡¡¡¡¢Í¡¡¿ôÃÍ·¿
bit¡¡¡¡¢Í¡¡ÏÀÍý·¿
money¡¡¢Í¡¡¿ôÃÍ·¿
¤Ç°·¤ï¤ì¤Þ¤¹¡£
ÆäËÊÑ´¹¤ò°Õ¼±¤¹¤ëɬÍפϤʤ«¤Ã¤¿¤è¤¦¤Ë»×¤¤¤Þ¤¹¡£
jBOLT¤Ç¤Ï¡¢nullÃͤò°·¤¦¾ì¹ç¤Ï¡¢Ãí°Õ¤¬É¬ÍפǤ¹¡£
Î㤨¤Ð¡¢DataMapper¤Ë¤Æ¡¢inset/update¤ÇnullÃͤòÀßÄꤷ¤¿¤¤¾ì¹ç¡¢Àþ¤ò°ú¤¤¤¿¤À¤±¤Ç¤ÏnullÃͤÏÀßÄꤵ¤ì¤Þ¤»¤ó¤Ç¤·¤¿¡£
¥Þ¥Ã¥×²èÌ̤ˤơ¢Á÷¤êÀè¤Î¹àÌܤΥץí¥Ñ¥Æ¥£¤Î·×»»ÃÍÍó¤Ë¤Æ¡¢if´Ø¿ô¤È¡¢isNull´Ø¿ô¤òÍѤ¤¤Æ¡¢nullÃͤ«Èݤ«¤ò³Îǧ¤·¤Æ¡¢null¤Î¾ì¹ç¤Ënull¤òÀßÄꤷ¤¿¤±¤ì¤ÐNull()´Ø¿ô¤òÀßÄꤹ¤ë¤è¤¦¤Ë¤·¤Þ¤¹¡£
jBOLTÆâÉô¤Ç¤Ï¡¢
int¡¡¡¡¢Í¡¡¿ôÃÍ·¿
bit¡¡¡¡¢Í¡¡ÏÀÍý·¿
money¡¡¢Í¡¡¿ôÃÍ·¿
¤Ç°·¤ï¤ì¤Þ¤¹¡£
ÆäËÊÑ´¹¤ò°Õ¼±¤¹¤ëɬÍפϤʤ«¤Ã¤¿¤è¤¦¤Ë»×¤¤¤Þ¤¹¡£
jBOLT¤Ç¤Ï¡¢nullÃͤò°·¤¦¾ì¹ç¤Ï¡¢Ãí°Õ¤¬É¬ÍפǤ¹¡£
Î㤨¤Ð¡¢DataMapper¤Ë¤Æ¡¢inset/update¤ÇnullÃͤòÀßÄꤷ¤¿¤¤¾ì¹ç¡¢Àþ¤ò°ú¤¤¤¿¤À¤±¤Ç¤ÏnullÃͤÏÀßÄꤵ¤ì¤Þ¤»¤ó¤Ç¤·¤¿¡£
¥Þ¥Ã¥×²èÌ̤ˤơ¢Á÷¤êÀè¤Î¹àÌܤΥץí¥Ñ¥Æ¥£¤Î·×»»ÃÍÍó¤Ë¤Æ¡¢if´Ø¿ô¤È¡¢isNull´Ø¿ô¤òÍѤ¤¤Æ¡¢nullÃͤ«Èݤ«¤ò³Îǧ¤·¤Æ¡¢null¤Î¾ì¹ç¤Ënull¤òÀßÄꤷ¤¿¤±¤ì¤ÐNull()´Ø¿ô¤òÀßÄꤹ¤ë¤è¤¦¤Ë¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
hitachijoho
Åê¹Æ¿ô: 53
![¾ïÏ¢ ¾ïÏ¢](../../uploads/rank3dbf8e9e7d88d.gif)
¤¤¤Ä¤â¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹¡£
º£¡¢Excle¥Õ¥¡¥¤¥ë¤«¤éMS SQL Server 2005¤Ë¥Ç¡¼¥¿¤Î°Ü¹Ô¤ò¤ä¤Ã¤Æ¤Þ¤¹¤¬¡¢Jbolt¤Ç¤Ï¡¢MS SQL Server 2005 ¤Îint,money,bit¤Ë¤Ä¤¤¤Æ¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ï¤É¤Î¤è¤¦¤ËÂбþ¤·¤Þ¤¹¤Ç¤·¤ç¤¦¤«¡©
²¼µ¤Î¤³¤È¤ò¼Â¸½¤·¤¿¤¤¤È»×¤¤¤Þ¤¹¡£
¡Excle¤Îcell¡Ö-1¡×¤ò¢ÍMS SQL Server 2005¤Îtable1¤Îcloum1¤Ë°Ü¹Ô¤·¤¿¤¤¤³¤È¡£
¢¨MS SQL Server 2005¤Îtable1¤Îcloum1¥Ç¡¼¥¿·¿¤Ïint¤Ç¤¹¡£
¢Excle¤Îcell¡Ö0¡×¤òMS SQL Server 2005¤Îtable1¤Îcloum2¤Ë°Ü¹Ô¤·¤¿¤¤¤³¤È¡£
¢¨MS SQL Server 2005¤Îtable1¤Îcloum2¥Ç¡¼¥¿·¿¤Ïmoney¤Ç¤¹¡£
£Excle¤Îcell¡Ö0¡×¤òMS SQL Server 2005¤Îtable1¤Îcloum3¤Ë°Ü¹Ô¤·¤¿¤¤¤³¤È¡£
¢¨MS SQL Server 2005¤Îtable1¤Îcloum3¥Ç¡¼¥¿·¿¤Ïbit¤Ç¤¹¡£
°Ê¾å¡¢¤ª¼ê¿ô¤Ç¤¹¤¬¡¢¤´²óÅú¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
º£¡¢Excle¥Õ¥¡¥¤¥ë¤«¤éMS SQL Server 2005¤Ë¥Ç¡¼¥¿¤Î°Ü¹Ô¤ò¤ä¤Ã¤Æ¤Þ¤¹¤¬¡¢Jbolt¤Ç¤Ï¡¢MS SQL Server 2005 ¤Îint,money,bit¤Ë¤Ä¤¤¤Æ¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ï¤É¤Î¤è¤¦¤ËÂбþ¤·¤Þ¤¹¤Ç¤·¤ç¤¦¤«¡©
²¼µ¤Î¤³¤È¤ò¼Â¸½¤·¤¿¤¤¤È»×¤¤¤Þ¤¹¡£
¡Excle¤Îcell¡Ö-1¡×¤ò¢ÍMS SQL Server 2005¤Îtable1¤Îcloum1¤Ë°Ü¹Ô¤·¤¿¤¤¤³¤È¡£
¢¨MS SQL Server 2005¤Îtable1¤Îcloum1¥Ç¡¼¥¿·¿¤Ïint¤Ç¤¹¡£
¢Excle¤Îcell¡Ö0¡×¤òMS SQL Server 2005¤Îtable1¤Îcloum2¤Ë°Ü¹Ô¤·¤¿¤¤¤³¤È¡£
¢¨MS SQL Server 2005¤Îtable1¤Îcloum2¥Ç¡¼¥¿·¿¤Ïmoney¤Ç¤¹¡£
£Excle¤Îcell¡Ö0¡×¤òMS SQL Server 2005¤Îtable1¤Îcloum3¤Ë°Ü¹Ô¤·¤¿¤¤¤³¤È¡£
¢¨MS SQL Server 2005¤Îtable1¤Îcloum3¥Ç¡¼¥¿·¿¤Ïbit¤Ç¤¹¡£
°Ê¾å¡¢¤ª¼ê¿ô¤Ç¤¹¤¬¡¢¤´²óÅú¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00