£¨×ªÔØ£©SQL 2K Êý¾ÝÀàÐÍ
(1)char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎĿոñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä³¤×Ö·ûÊý¾ÝÔò²»»áÒÔ¿Õ¸ñÌî³ä¡£text´æ´¢¿É±ä³¤¶ÈµÄ·ÇUnicodeÊý¾Ý£¬×î´ó³¤¶ÈΪ2^31-1(2,147,483,647)¸ö×Ö·û¡£
ºóÃæÈýÖÖÊý¾ÝÀàÐͺÍÇ°ÃæµÄÏà±È£¬´ÓÃû³ÆÉÏ¿´Ö»ÊǶàÁ˸ö×Öĸ"n"£¬Ëü±íʾ´æ´¢µÄÊÇUnicodeÊý¾ÝÀàÐ͵Ä×Ö·û¡£Ð´¹ý³ÌÐòµÄÅóÓѶÔUnicodeÓ¦¸ÃºÜÁ˽⡣×Ö·ûÖУ¬Ó¢ÎÄ×Ö·ûÖ»ÐèÒªÒ»¸ö×Ö½Ú´æ´¢¾Í×ã¹»ÁË£¬µ«ºº×ÖÖڶ࣬ÐèÒªÁ½¸ö×Ö½Ú´æ´¢£¬Ó¢ÎÄÓ뺺×Öͬʱ´æÔÚʱÈÝÒ×Ôì³É»ìÂÒ£¬Unicode×Ö·û¼¯¾ÍÊÇΪÁ˽â¾ö×Ö·û¼¯ÕâÖÖ²»¼æÈݵÄÎÊÌâ¶ø²úÉúµÄ£¬ËüËùÓеÄ×Ö·û¶¼ÓÃÁ½¸ö×Ö½Ú±íʾ£¬¼´Ó¢ÎÄ×Ö·ûÒ²ÊÇÓÃÁ½¸ö×Ö½Ú±íʾ¡£nchar¡¢nvarcharµÄ³¤¶ÈÊÇÔÚ1µ½4000Ö®¼ä¡£ºÍchar¡¢varchar±È½Ï£ºnchar¡¢nvarcharÔò×î¶à´æ´¢4000¸ö×Ö·û£¬²»ÂÛÊÇÓ¢ÎÄ»¹ÊǺº×Ö£»¶øchar¡¢varchar×î¶àÄÜ´æ´¢8000¸öÓ¢ÎÄ£¬4000¸öºº×Ö¡£¿ÉÒÔ¿´³öʹÓÃnchar¡¢nvarcharÊý¾ÝÀàÐÍʱ²»Óõ£ÐÄÊäÈëµÄ×Ö·ûÊÇÓ¢ÎÄ»¹ÊǺº×Ö£¬½ÏΪ·½±ã£¬µ«ÔÚ´æ ......
ÕâÁ½Ì춼ûÓкúÃѧϰ£¬½ñÌìÖÕÓÚËãͶÈëÁËЩ£¬ÓÉÓڿγ̵ĹØÏµ£¬ÎÒµÄsqlÒ²ÊÇͬvbÒ»ÆðѧϰµÄ¡£ËäȻ֪µÀ̰¶à½À²»À㬿ÉÊǰ´ÕÕʵ¼ÊÇé¿ö£¬ÎÒÍêȫûÓÐÀíÓÉÅׯúsqlµÄ¡£
×î½ü¶¼°Ñʱ¼äͶÈëµ½vbºÍÃæÏò¶ÔÏóÖУ¬sql½ñÌìºÃºÃ¸´Ï°ÁËÏ£¬´Ócreate database ¿ªÊ¼£¬create table£¬alter table £¬ add constraint …… check£¨£©£¬insert into……values£¨£©£¬insert …… select……union£¬½ñÍíÎÒ°ÑÕâЩ¶¼¸´Ï°ÁËÒ»±é£¬»¹ÓÐѧÁËһЩ»ù±¾µÄ²éѯ£¬Ê±¼ä¾ÍÒѾ¹ýÈ¥ÁË¡£¸Ð¾õ»¹Í¦³äʵµÄ£¬ËäÈ»ºÜ¼òµ¥£¬µ«ÊÇÒ²¾ÍÊÇÒòΪÕâÑùÎÒ²ÅÓмÌÐøÏÂÈ¥µÄÓÂÆøºÍÐÅÐİ¡£¬ÎÒÏàÐÅ£¬ÔÚÕâÁ½ÄêÀÎÒ»á°Ñ×Ô¼º´ÓÒ»ÎÞËùÖªµÄѧÉú±ä³ÉÒ»¸öºÏ¸ñµÄ³ÌÐòÔ±£¬Ö»ÊǼ°¸ñ£¬²»ÒªÇóÓÅÐ㣬ÒòΪÕâÊÇÎÒ½ñºóÂþ³¤µÄ×ßѰµÀ·¡£
½ñÌìÈ¥¶îÍâµÄÌýÁËc++µÄ¿Î£¬ÊÇÒÔǰÀÏʦÉϵģ¬Î»ÖúÜÔ¶£¬Ã»Ìýµ½Ê²Ã´£¬µ«ÊÇËû¸øµÄcppÎļþÎÒ×ÐϸµÄ¿´ÁË¿´¡£ÊǺºÅµÒÁÎÊÌ⣬½²µÄÊǵݹéµÄÎÊÌ⣬ÎÒ¿´Á˺ܾòŰÑÔõôµÝ¹éµ÷Óøø¿´Çå³þ£¬µ«ÊÇÖ±µ½ÏÖÔÚ»¹²»ÄÜ˵ÍêÈ«ÕÆÎÕ¡£µÝ¹éÎÒÊǶ®ÁË£¬µ«ÊÇÄǸöËã·¨ÎÒûŪµÃ³¹µ×Ã÷°×¡£ÒÔǰÌýµÄʱºò¾ÍÒÅÁôÏÂÀ´µÄÎÊÌ⣬ÏÖÔÚÓÖÊǶÔÎҵĿ¼ÑéÁË¡£²»¹ýÓÐÁ˵ã»ù´¡£¬ÎÒ»¹ÊǰѺ¯ÊýµÄµ÷Óà ......
ÔÚPL/SQLÖÐÒ²ÌṩGOTOÓï¾ä,ÆäÓï·¨ÊÇ
GOTO label;
ÕâÀïlabelÊÇÔÚPL/SQL¿éÖж¨ÒåµÄ±êÇ©.±êÇ©ÊÇÓÃË«¼ýÍ·À¨ºÅÀ¨ÆðÀ´µÄ.µ±Ö´ÐÐGOTOÓï¾äµÄʱºò,¿ØÖÆ»áÁ¢¼´×ªµ½ÓɱêÇ©±êʶµÄÓï¾ä.
1.¶ÔÓÚGOTOµÄÏÞÖÆ
a.¶ÔÓÚ¿é,Ñ»·»òÕßIFÓï¾ä¶øÑÔ,ÏëÒª´ÓÍâ²ãÌøµ½ÄÚ²ãÊÇ·Ç·¨µÄ.
b.ʹÓÃGOTO×Ó¾ä´ÓÒ»¸öIF×Ó¾äÌøµ½ÁíÒ»¸ö×Ó¾äÖÐÒ²ÊÇ·Ç·¨µÄ.
begin
if x>3 then
...
goto<<lbl>>
else
<<lbl>>
...
end if;
end;
c.´ÓÒ»¸öÒì³£´¦Àí¿éÄÚÌø×ªµ½µ±Ç°¿éÊÇ·Ç·¨µÄ¡£
2.Ϊѻ·É趨±êÇ©
Ñ»·±¾ÉíÊÇ¿ÉÒÔ±»É趨±êÇ©µÄ¡£Èç¹û½øÐÐÁËÉ趨£¬ÄÇô¿ÉÒÔÔÚEXITÓï¾äÖÐʹÓøñêǩָÃ÷ÒªÍ˳öÄĸöÑ»·.ÀýÈç:
<<l_outer>>
for v_outer_index in 1..10 loop
...
<<I_inner>>
for v_inner_index in 1..30 loop
...
if v_outer_index > 5 then
EXIT I_outer;
end if;
end loop I_inner;
end loop I_outer;
Èç¹ûÑ»·É趨Á˱êÇ©£¬ÄÇô¿ÉÒÔÔÚEND LOOPÓï¾äµÄºóÃæ°üº¬¸Ã±êÇ©Ãû,ÈçÉÏÃæËùʾ.
3.½÷É÷µÄʹÓÃGOTOÓï¾ä
ÔÚʹÓÃGOTOÓï¾äʱһ¶¨ÒªÐ¡ÐÄ,²»È»¶¼ÊÇÐ©ÌøÀ´ÌøÈ¥µÄ´úÂë,ºÜÄÑÀí½âÒ²ºÜÄÑά»¤.
¼¸ºõËùÓÐʹÓÃGOTOµÄÇé¿ö¶¼¿ÉÒÔʹÓÃÆäËûµÄPL/SQL¿ØÖƽṹ ......
×¢'svw'Ϊ³öÎÊÌâµÄÊý¾Ý¿â,´Ë·½Ê½¶Ôsql7.0ÒÔÉϰ汾ÓÐЧ,ÆäËüµÍ°æ±¾Îª²âÊÔ
sp_configure 'allow',1
go
reconfigure with override
go
update sysdatabases set status=32768 where name='svw'
go
dbcc rebuild_log('svw','D:\mssql7\data\svw_Log.ldf')
go
update sysdatabases set status=0 where name='svw'
go
sp_configure 'allow',0
go
reconfigure with override
go
dbcc checkdb('svw')
go
DBCC CHECKTABLE (sysobjects)
DBCC CHECKTABLE (sysindexes)
DBCC CHECKTABLE (syscolumns )
DBCC CHECKTABLE (systypes) ......
PHP °æ±¾¸÷Ò죬ÒѾֹͣÉý¼¶¿ª·¢µÄÓÐ 4.0 ϵÁÐµÄ 4.4.x£¬µ«ÏÖÔÚ»¹Óв¿·ÖÉú²ú»·¾³ÔÚÅÜÕâ¸ö°æ±¾£¬ÐèÒª¼ÌÐøÎ¬»¤´úÂë¡£PHP 5.0 ϵÁÐÊÇÏÖÔÚ¿ª·¢ºÍÓ¦ÓõÄÖ÷Á÷°æ±¾£¬ÓÐ 5.1.x ºÍ 5.2.x ϵÁС£PHP 6.0 Ŀǰ»¹ÊÇÊÔÓð汾£¬Óà PHP ¿ª·¢Èí¼þ²úÆ·µÄÈËÏÖÔÚ¿ÉÒÔÔ¤ÏÈ×÷¼æÈÝÐÔ²âÊÔ¡£
PHP Ö§³ÖµÄÊý¾Ý¿âºÜ¶à£¬°üÀ¨ PHP ±¾Éí×Ô´øµÄÊý¾Ý¿âÇý¶¯×é¼þ£¬ÀýÈç mysql.dll¡¢oci_oracle µÈ¡£PHP ´Ó 5.1 °æ±¾ÒÔºóÕýÔÚÁ¦ÍÆÆäͨÓõÄÊý¾Ý¿âÇý¶¯×é¼þ PDO£¬Í¨¹ýÕâ¸ö¸ß¶È³éÏóµÄÊý¾Ý¿â´æÈ¡×é¼þ£¬PHP ¿ÉÒÔÖ§³ÖĿǰ¾ø´ó¶àÊýÊý¾Ý¿â²úÆ·£¬¶øÇÒÕâ¸öÊýÁ¿»¹ÔÚÔö¼Ó£¬¾ßÓм«´óµÄÀ©Õ¹ÐÔ¡£¶øµÚÈý·½³§¼ÒºÜÔç¾ÍÔÚ¿ª·¢ ADODB Êý¾Ý¿â´æÈ¡×é¼þ£¨http://adodb.sourceforge.net/£©£¬ÏÖÔÚÈÔÈ»ÔÚ¼ÌÐø½øÕ¹ÖС£
PHP ×ÔÉíÖ§³ÖµÄÊý¾Ý¿â×é¼þ£¬Ä¿Ç°×îÁ÷ÐеÄÊÇ MySQL ×é¼þ¡£PHP4.0 ºÍ 5.0 °æ±¾¶Ô Oracle µÄÖ§³ÖʹÓÃÁ˲»Í¬µÄº¯Êý×飬5.0 ¼æÈÝ 4.0£¬µ«º¯ÊýÃûÒѾ¸ü»»ÁË¡£PHP4.0 ÓõÄÊÇ OCILogon()¡¢OCIParse()¡¢OCIExecute()¡¢OCIFetchInto()µÈº¯Êý¡£¶ø PHP5.0 ÓõÄÊÇ oci_connect()¡¢oci_parse¡¢oci_bind_by_name()¡¢oci_execute()¡¢oci_fetch_all()µÈµÈº¯Êý£¬ÄÜ¿´³öÀ´ÊÇÏò MySQL µ ......
1£®°²×°apache 2.2.3£¬Íê³Éºó£¬Í¨ÖªÇøÓòÒà¾ÍÊÇÓÒϽǷÅQQÄĶù»áÓÐÒ»¸öСͼ±ê£¬Èç¹ûÁÁ×ÅÂ̵Ƶϰ£¬¹§Ï²°²×°³É¹¦£¬ºìµÆÔòÒªÏë°ì·¨½â¾ÈÁË(Ö»Òª80¶Ë¿Ú²»±»Õ¼Óã¬Í¨³£ÊDz»»áÁÁºìµÆµÄ)£¡Æä¼ä×¢ÒâÌîдNetwork Domain£»Sever Name£»Administrator's Email AddressÕâÈýÏ·¾¶²ÉÓÃÁËĬÈÏ£ºC:\Program Files\
¡¡¡¡2£®°²×°MySQL-5.0.18£¬ÔËÐÐMysql°²×°Îļþ£¬²»¶ÏµÄNext£¬Æä¼äÊäÈëÒ»¸öÓÊÏ䣬ÉèÖÃÃÜÂëºÍÈ·ÈÏÃÜÂë……
¡¡¡¡3£®¿ªÊ¼ÅäÖÃPHP£¬ÕâÀïËãÊÇÄѵã°É£¡°´ËûÈ˽̳ÌÒ»²½²½×öµÄ£¬ÒòΪÅäÖÃʱҪÌí¼ÓºÜ¶àµÄ¹ØÓÚÎÒÃǸմ´½¨µÄÎļþ¼ÐµÄ²ÎÊý¡£ÔÚCÅÌ´´½¨Ò»¸öÎļþ¼Ð£¬ÃüÃûΪphp£¬°ÑÏÂÔØÀ´µÄphpÎļþ°ü£¨php-5.1.6-Win32.zip»ò±ðµÄ°æ±¾£©½âѹµ½ÆäÖС£
¡¡¡¡4£®ÔÚEÅÌ´´½¨Îļþ¼Ð²¢ÃüÃûΪhttproot£¨ÊÇÓÃÀ´·ÅÍøÒ³µÄÎļþ¼Ð£¬ÒÔ¹©apache¶ÁÈ¡£©½«phpmyadminµÄÕû¸öÎļþ¼Ðѹµ½E:\httprootÀ½âѹºóÎļþµÄ·¾¶ÊÇE:\httproot\phpmyadmin2.x.x xxxÓÖ°ÑE:\httprootÀïµÄÎļþ¼Ðphpmyadmin2.x.xxxxÖØÃüÃûΪphpmyadmin£¬ÕâÑù×öÊDZãÓÚä¯ÀÀ¡£
¡¡¡¡5£®ÅäÖÃapacheµÄÅäÖÃÎļþhttpd.conf
¡¡¡¡Í¨¹ý→¿ªÊ¼→ËùÓгÌÐò→Apache HTTP Server 2.0.55 →Configure Apache Server →Edit The Ap ......