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 ÊǸ½¼ÓÊý¾Ý¿âÎļþ
Ïà¹ØÎĵµ£º
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£ºÊ ......
BSϵͳÖУ¬´«Í³µÄ×¢Èë¹¥»÷ÊÖ¶ÎÓкܶࡣ
×î»ù±¾µÄ£¬ÀûÓõ¥ÒýºÅ¹¥»÷µÄ£¬ºÜÈÝÒ×½â¾ö£¬ÓÃÀàËÆÓÚQuotedStr()£¨Êµ¼Ê¿ª·¢ÊÇÆäËûÓïÑÔ£¬ÕâÀïÓÃDELPHIÖеĺ¯Êý´úÌæ£©µÄº¯Êý´¦Àí²ÎÊý¼´¿É¡£
µ«Êµ¼ÊÓ¦ÓÃÖУ¬²»¿É±ÜÃâ»áÓÐһЩӦÓÃÐèÒªÖ±½Ó´«µÝ²ÎÊý£¬ÀýÈç±íÃû¡¢²éѯÌõ¼þ¡¢ÅÅÐòÌõ¼þµÈµÈ
¶ÔÕâЩӦÓõÄ×¢Èë¹¥»÷·À²»Ê¤·À¡£
ÎÒ¿¼ÂÇÁËÒ»¸ ......
ÔÚPL/SQL¿éÖв»ÄÜÖ±½Óµ÷ÓÃDDLÓï¾ä£¬¿ÉÒÔÀûÓÃÏÂÃæµÄ·½·¨½øÐе÷ÓÃ
·½·¨Ò»£º¶¯Ì¬SQL
execute immediate 'CREATE TABLE newtable AS
&nb ......
ǰÑÔ
InternetµÄ¹æÄ£Ã¿Ò»°ÙÌì¾Í»áÔö³¤Ò»±¶£¬¿Í»§Ï£Íû»ñµÃ7Ìì×24СʱµÄ²»¼ä¶Ï¿ÉÓÃÐÔ¼°½Ï¿ìµÄϵͳ·´Ó¦Ê±¼ä£¬¶ø²»Ô¸ÂŴο´µ½Ä³¸öÕ¾µã“Server Too Busy”¼°Æµ·±µÄϵͳ¹ÊÕÏ¡£
Ëæ×ÅÒµÎñÁ¿µÄÌá¸ß,ÒÔ¼°·ÃÎÊÁ¿ºÍÊý¾ÝÁ÷Á¿µÄ¿ìËÙÔö³¤£¬ÍøÂç¸÷¸öºËÐIJ¿·ÖµÄ´¦ÀíÐÔÄܺͼÆËãÇ¿¶ÈÒ²ÏàÓ¦Ôö´ó£¬Ê¹µÃµ¥Ò»É豸¸ù±¾ÎÞ·¨³Ðµ£¡£ ......
PL/SQLµ¥Ðк¯ÊýºÍ×麯ÊýÏê½â
¡¡ º¯ÊýÊÇÒ»ÖÖÓÐÁã¸ö»ò¶à¸ö²ÎÊý²¢ÇÒÓÐÒ»¸ö·µ»ØÖµµÄ³ÌÐò¡£ÔÚSQLÖÐOracleÄÚ½¨ÁËһϵÁк¯Êý£¬ÕâЩº¯Êý¶¼¿É±»³ÆÎªSQL»òPL/SQLÓï¾ä£¬º¯ÊýÖ÷Òª·ÖΪÁ½´óÀࣺ
¡¡¡¡ µ¥Ðк¯Êý ×麯Êý
¡¡¡¡SQLÖеĵ¥Ðк¯Êý
¡¡¡¡SQLºÍPL/SQLÖÐ×Ô´øºÜ¶àÀ ......