VFP ·R¥ÎªÌªÀ°Ï ­º­¶ VFP ·R¥ÎªÌªÀ°Ï
¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
 
 ±`¨£°ÝÃD±`¨£°ÝÃD   ·j´M·j´M   ·|­û¦Cªí·|­û¦Cªí   ·|­û¸s²Õ·|­û¸s²Õ   ·|­ûµù¥U·|­ûµù¥U 
 ­Ó¤H¸ê®Æ­Ó¤H¸ê®Æ   µn¤JÀˬd±zªº¨p¤H°T®§µn¤JÀˬd±zªº¨p¤H°T®§   µn¤Jµn¤J

½Ð°ÝSQL2000¸ê®Æ®wªº®e¶q

 
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD  
µoªí¤H ¤º®e
caney



µù¥U®É¶¡: 2003-09-22
¤å³¹: 9


²Ä 1 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤Q¤ë 12, 2007 2:30 pm    ¤å³¹¥DÃD: ½Ð°ÝSQL2000¸ê®Æ®wªº®e¶q ¤Þ¨¥¦^ÂÐ

MS-SQL2000¸ê®Æ®w(.MDF)¬O¦s¦¨¤@­ÓÀÉ®×,½Ð°Ý¨ä¬O§_¦³³Ì¤j®e¶q¤§­­¨î?¹F¨ì¦h¤Ö®e¶q(GB)®É·|Ãz±¼,ÁÂÁÂ!
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§
syntech



µù¥U®É¶¡: 2003-05-16
¤å³¹: 4211
¨Ó¦Û: Taipei,Taiwan

²Ä 2 ¼Ó

µoªíµoªí©ó: ¬P´Á¤­ ¤Q¤ë 12, 2007 3:43 pm    ¤å³¹¥DÃD: ¤Þ¨¥¦^ÂÐ

¦³°÷Äê,³shelp ³£¤£·|¬d
--------------------
³Ì¤j®e¶q³W®æ
²Ä¤@­Óªí®æ«ü©w©Ò¦³ Microsoft—û SQL Server—ü 2000 ª©¥»³£¬Û¦Pªº³Ì¤j®e¶q¡C²Ä¤G­Ó»P²Ä¤T­Óªí®æ«h«ü©w«h¬°¨Ì SQL Server 2000 ªºª©¥»»P§@·~¨t²Î¦Ó²§ªº®e¶q¡C

¤Uªí«ü©w Microsoft SQL Server ¸ê®Æ®w¤¤©Ò©w¸q©Î Transact-SQL ³¯­z¦¡©Ò°Ñ¦Ò¤§¤£¦Pª«¥óªº³Ì¤j¤j¤p»P¼Æ¥Ø¡C ªí¤¤¤£¥]§t Microsoft—û SQL Server 2000—ü Windows—û CE ª©¡C

³Ì¤j¤j¤p/¼Æ¥Ø
ª«¥ó SQL Server 7.0 SQL Server 2000
§å¦¸¤j¤p 65,536 * ºô¸ô«Ê¥]¤j¤p1 65,536 * ºô¸ô«Ê¥]¤j¤p1
¨C­Óµu¦r¦ê¸ê®Æ¦æªº¦ì¤¸²Õ 8,000 8,000
¨C­Ó text¡Bntext ©Î image ¸ê®Æ¦æªº¦ì¤¸²Õ 2 GB-2 2 GB-2
¨C­Ó GROUP BY¡BORDER BY ªº¦ì¤¸²Õ 8,060
¨C­Ó¯Á¤Þªº¦ì¤¸²Õ 900 9002
¨C­Ó¥~³¡¯Á¤ÞÁ䪺¦ì¤¸²Õ 900 900
¨C­Ó¥D¯Á¤ÞÁ䪺¦ì¤¸²Õ 900 900
¨C­Ó¸ê®Æ¦Cªº¦ì¤¸²Õ 8,060 8,060
¹w¦sµ{§Çªº¨Ó·½¤å¦rªº¦ì¤¸²Õ ¸û¤pªº§å¦¸¤j¤p©Î 250 MB ¸û¤pªº§å¦¸¤j¤p©Î 250 MB
¨C­Ó¸ê®ÆªíªºÂO¶°¯Á¤Þ 1 1
GROUP BY¡BORDER BY ¤¤ªº¸ê®Æ¦æ ¶È¨ü­­©ó¦ì¤¸²Õ¼Æ¥Ø
GROUP BY WITH CUBE ©Î WITH ROLLUP ³¯­z¦¡ªº¸ê®Æ¦æ©Î¹Bºâ¦¡ 10
¨C­Ó¯Á¤Þªº¸ê®Æ¦æ 16 16
¨C­Ó¥~³¡¯Á¤ÞÁ䪺¸ê®Æ¦æ 16 16
¨C­Ó¥D¯Á¤ÞÁ䪺¸ê®Æ¦æ 16 16
¨C­Ó°ò©³¸ê®Æªíªº¸ê®Æ¦æ 1,024 1,024
¨C­Ó SELECT ³¯­z¦¡ªº¸ê®Æ¦æ 4,096 4,096
¨C­Ó INSERT ³¯­z¦¡ªº¸ê®Æ¦æ 1,024 1,024
¨C­Ó¥Î¤áºÝªº³s½u ³]©wªº³s½uªº³Ì¤j¼Æ­È ³]©wªº³s½uªº³Ì¤j¼Æ­È
¸ê®Æ®w¤j¤p 1,048,516 TB3 1,048,516 TB3
¨C­Ó SQL Server °õ¦æ­ÓÅ骺¸ê®Æ®w 32,767 32,767
¨C­Ó¸ê®Æ®wªºÀɮ׸s²Õ 256 256
¨C­Ó¸ê®Æ®wªºÀÉ®× 32,767 32,767
Àɮפj¤p (¸ê®Æ) 32 TB 32 TB
Àɮפj¤p (°O¿ýÀÉ) 4 TB 32 TB
¨C­Ó¸ê®Æªíªº¥~³¡¯Á¤ÞÁä¸ê®Æªí°Ñ¦Ò 253 253
ÃѧO¶µªø«× (¥H¦r¤¸¬°³æ¦ì) 128 128
¨C³¡¹q¸£ªº°õ¦æ­ÓÅé N/A 16
¥]§t SQL ³¯­z¦¡ªº¦r¦êªø«× (§å¦¸¤j¤p) 65,536 * ºô¸ô«Ê¥]¤j¤p1 65,536 * ºô¸ô«Ê¥]¤j¤p1
¨C­Ó³s½uªºÂê©w ¨C­Ó¦øªA¾¹ªº³Ì¤jÂê©w ¨C­Ó¦øªA¾¹ªº³Ì¤jÂê©w
¨C­Ó SQL Server °õ¦æ­ÓÅ骺Âê©w 2,147,483,647 (ÀRºA)
40% ªº SQL Server °O¾ÐÅé (°ÊºA) 2,147,483,647 (ÀRºA)
40% ªº SQL Server °O¾ÐÅé (°ÊºA)
±_ª¬ªº¹w¦sµ{§Ç¼h¯Å 32 32
±_ª¬ªº¤l¬d¸ß (Subquery) 32 32
±_ª¬ªºÄ²µoµ{§Ç¼h¯Å 32 32
¨C­Ó¸ê®Æªíªº«DÂO¶°¯Á¤Þ 249 249
¦P®É¶}±Ò©ó¤@­Ó SQL Server4 °õ¦æ­ÓÅ骺ª«¥ó 2,147,483,647 (©Î¥i¥Îªº°O¾ÐÅé) 2,147,483,647 (©Î¥i¥Îªº°O¾ÐÅé)
¸ê®Æ®w¤¤ªºª«¥ó 2,147,483,6474 2,147,483,6474
¨C­Ó¹w¦sµ{§Çªº°Ñ¼Æ 1,024 1,024
¨C­Ó¸ê®Æªíªº REFERENCES 253 253
¨C­Ó¸ê®Æªíªº¸ê®Æ¦C ¶È¨ü­­©ó¥i¥ÎªºÀx¦s°Ï ¶È¨ü­­©ó¥i¥ÎªºÀx¦s°Ï
¨C­Ó¸ê®Æ®wªº¸ê®Æªí ¨ü­­©ó¸ê®Æ®w¤¤ªºª«¥ó¼Æ¥Ø4 ¨ü­­©ó¸ê®Æ®w¤¤ªºª«¥ó¼Æ¥Ø4
¨C­Ó SELECT ³¯­z¦¡ªº¸ê®Æªí 256 256
¨C­Ó¸ê®ÆªíªºÄ²µoµ{§Ç ¨ü­­©ó¸ê®Æ®w¤¤ªºª«¥ó¼Æ¥Ø4 ¨ü­­©ó¸ê®Æ®w¤¤ªºª«¥ó¼Æ¥Ø4
¨C­Ó¸ê®Æªíªº UNIQUE ¯Á¤Þ©Î±ø¥ó¬ù§ô 249 ­Ó«DÂO¶°»P 1 ­ÓÂO¶° 249 ­Ó«DÂO¶°»P 1 ­ÓÂO¶°

_________________
¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊ­p¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý

½ÐÁpµ¸§Ú­Ì,¤]³\§Ú­ÌÀ°±o¤W¦£
¦^³»ºÝ
À˵ø·|­û­Ó¤H¸ê®Æ µo°e¨p¤H°T®§ µo°e¹q¤l¶l¥ó AIM Address
±q¤§«eªº¤å³¹¶}©lÅã¥Ü:   
µoªí·s¥DÃD   ¦^ÂÐ¥DÃD    VFP ·R¥ÎªÌªÀ°Ï ­º­¶ -> SQL °Q½×°Ï ©Ò¦³ªº®É¶¡§¡¬° ¥x¥_®É¶¡ (GMT + 8 ¤p®É)
²Ä1­¶(¦@1­¶)

 
«e©¹:  
±z µLªk ¦b³o­Óª©­±µoªí¤å³¹
±z µLªk ¦b³o­Óª©­±¦^ÂФ峹
±z µLªk ¦b³o­Óª©­±½s¿è¤å³¹
±z µLªk ¦b³o­Óª©­±§R°£¤å³¹
±z µLªk ¦b³o­Óª©­±¶i¦æ§ë²¼
±z µLªk ¦b³o­Óª©­±ªþ¥[ÀÉ®×
±z µLªk ¦b³o­Óª©­±¤U¸üÀÉ®×


Powered by phpBB © 2001, 2005 phpBB Group
¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@