|
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¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
caney
µù¥U®É¶¡: 2003-09-22 ¤å³¹: 9
²Ä 1 ¼Ó
|
µ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±¼,ÁÂÁÂ! |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 2 ¼Ó
|
µ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¦£ |
|
¦^³»ºÝ |
|
|
|
|
±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§@
|