Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql server Öд´½¨Êý¾Ý¿âµÄ¶¨Òå

´´½¨Êý¾Ý¿â
create DataBase database_name
    [on       [primary]
                [/<filespec/>[1,.......n]]
                [,<filegroup>[1,.......n]]
   ]
  [LOG ON {<filespec>[1,.......n]} ]
  [FOR LOAD|FOR ATTACH]
  <filespec>::=([
                          [NAME=logical_filename,]
                          FILENAME='os_file_name'
                          [,SIZE=size]
                          [,MAXSIZE={max_size|UNLIMITED}]
                          [,FILEGROUP=growth_increment ]
)[,.......n]
<filegroup>::=FILEGROUP filegroup_name<filespec>[,.......n]
±»[]À¨ÖеÄÄÚÈݱíʾ¿ÉÓлò¿É²»ÓÐ
[1,....n]±íʾÔÚÀ¨ºÅÇ°ÃæµÄÏî¿ÉÒÔ³öÏÖ1´Î»òN´Î
±»<>À¨ÖеÄÄÚÈݱíʾÀïÃæµÄ¾ßÌåÄÚÈÝ»áÔÚÏÂÎÄÖÐÏêϸ˵Ã÷
FOR ATTACH ÊǸ½¼ÓÊý¾Ý¿âÎļþ               


Ïà¹ØÎĵµ£º

MySQL ×Ö·û¼¯µ¼ÖÂSQLÁ¬½ÓÖ®ºóÖÐÎÄÂÒÂëµÄÎÊÌ⣡

character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......

ÈçºÎ·ÀÖ¹SQL×¢Èë¹¥»÷

BSϵͳÖУ¬´«Í³µÄ×¢Èë¹¥»÷ÊÖ¶ÎÓкܶࡣ
×î»ù±¾µÄ£¬ÀûÓõ¥ÒýºÅ¹¥»÷µÄ£¬ºÜÈÝÒ×½â¾ö£¬ÓÃÀàËÆÓÚQuotedStr()£¨Êµ¼Ê¿ª·¢ÊÇÆäËûÓïÑÔ£¬ÕâÀïÓÃDELPHIÖеĺ¯Êý´úÌæ£©µÄº¯Êý´¦Àí²ÎÊý¼´¿É¡£
µ«Êµ¼ÊÓ¦ÓÃÖУ¬²»¿É±ÜÃâ»áÓÐһЩӦÓÃÐèÒªÖ±½Ó´«µÝ²ÎÊý£¬ÀýÈç±íÃû¡¢²éѯÌõ¼þ¡¢ÅÅÐòÌõ¼þµÈµÈ
¶ÔÕâЩӦÓõÄ×¢Èë¹¥»÷·À²»Ê¤·À¡£
ÎÒ¿¼ÂÇÁËÒ»¸ ......

PL/SQL¿éÖÐÈçºÎµ÷ÓÃDDLÓï¾ä

ÔÚPL/SQL¿éÖв»ÄÜÖ±½Óµ÷ÓÃDDLÓï¾ä£¬¿ÉÒÔÀûÓÃÏÂÃæµÄ·½·¨½øÐе÷ÓÃ
·½·¨Ò»£º¶¯Ì¬SQL
execute immediate 'CREATE TABLE newtable AS
                             &nb ......

SQL Server 2005ʵÏÖ¸ºÔؾùºâ

ǰÑÔ
InternetµÄ¹æÄ£Ã¿Ò»°ÙÌì¾Í»áÔö³¤Ò»±¶£¬¿Í»§Ï£Íû»ñµÃ7Ìì×24СʱµÄ²»¼ä¶Ï¿ÉÓÃÐÔ¼°½Ï¿ìµÄϵͳ·´Ó¦Ê±¼ä£¬¶ø²»Ô¸ÂŴο´µ½Ä³¸öÕ¾µã“Server Too Busy”¼°Æµ·±µÄϵͳ¹ÊÕÏ¡£
Ëæ×ÅÒµÎñÁ¿µÄÌá¸ß,ÒÔ¼°·ÃÎÊÁ¿ºÍÊý¾ÝÁ÷Á¿µÄ¿ìËÙÔö³¤£¬ÍøÂç¸÷¸öºËÐIJ¿·ÖµÄ´¦ÀíÐÔÄܺͼÆËãÇ¿¶ÈÒ²ÏàÓ¦Ôö´ó£¬Ê¹µÃµ¥Ò»É豸¸ù±¾ÎÞ·¨³Ðµ£¡£ ......

PL/SQLµ¥Ðк¯ÊýºÍ×麯ÊýÏê½â

PL/SQLµ¥Ðк¯ÊýºÍ×麯ÊýÏê½â
 
 ¡¡ º¯ÊýÊÇÒ»ÖÖÓÐÁã¸ö»ò¶à¸ö²ÎÊý²¢ÇÒÓÐÒ»¸ö·µ»ØÖµµÄ³ÌÐò¡£ÔÚSQLÖÐOracleÄÚ½¨ÁËһϵÁк¯Êý£¬ÕâЩº¯Êý¶¼¿É±»³ÆÎªSQL»òPL/SQLÓï¾ä£¬º¯ÊýÖ÷Òª·ÖΪÁ½´óÀࣺ
 ¡¡¡¡ µ¥Ðк¯Êý    ×麯Êý
  
¡¡¡¡SQLÖеĵ¥Ðк¯Êý
 
¡¡¡¡SQLºÍPL/SQLÖÐ×Ô´øºÜ¶àÀ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ