SQL Server2008°¸ÀýÖ®CyberSavvy ¹«Ë¾
CyberSavvy ¼áÐÅÈí¼þ×Ô¶¯»¯¿ÉÒÔÈÿͻ§ÇáËÉÏíÊÜÉú»î¡£DataPlace ÊǸù«Ë¾µÄÈí¼þ¼´·þÎñ½â¾ö·½°¸£¬Ò²¿É³Æ֮Ϊ“Êý¾Ý¿â¹¤³§”£¬ËüÄܹ»ÈÃÃæÏò¼¼ÊõÒÔ¼°ÃæÏòÉÌÎñµÄÓû§´´½¨²¢ÐÞ¸Ä×Ô¼ºµÄÊý¾Ý¿â£¬¶øCyberSavvy ¹«Ë¾½«Îª¸ÃÊý¾Ý¿âÌṩÍйܷþÎñ¡£Òò´ËCyberSavvy ¹«Ë¾ÐèÒªÅÍʯ°ã¼á¹ÌµÄÊý¾Ý¿â£¬²¢Í¨¹ýÍòÎÞһʧµÄÊý¾Ý´«Êä»úÖÆÀ´Ö§³Ö¿Í»§¶Ë£¨¼´SmartClient£©Í¬ºǫ́Êý¾Ý¿âÖ®¼äµÄͨÐÅ¡£CyberSavvy ÔÚ΢ÈíÓ¦ÓóÌÐòƽ̨Öв¿ÊðÆä½â¾ö·½°¸£¬¼´²ÉÓÃMicrosoft SQL Server™ 2008 Enterprise Edition ×÷Ϊ·þÎñ¶Ë£¬SQL Server 2008 Express Edition ×÷Ϊ¿Í»§¶Ë¡£CyberSavvy ÒѾÌåÑéµ½ÁËSQL Server 2008 Ëù´øÀ´µÄһϵÁкô¦£¬°üÀ¨¼¯³ÉµÄ¿ª·¢»·¾³¡¢ÀûÓñ¸·ÝѹËõ¹¦ÄÜÀ´¼õÉÙÊý¾Ý´æ´¢¡¢ÀûÓÃSQL Server Service Broker ´ÓÈÝʵÏÖ×Ô¶¯»¯¡¢¼°Æä¿ÉÉìËõÐÔ¡£
»ù±¾Çé¿ö
CyberSavvy ¹«Ë¾Î»ÓÚ»ªÊ¢¶ÙÖݵÄRedmond, ¸ÃÈí¼þ¹«Ë¾¹²ÓÐ17ÃûSOHO °ì¹«µÄ¿ª·¢ÈËÔ±£¬·Ö²¼ÓÚÃÀ¹úºÍ¼ÓÄôó¡£×÷Ϊ΢ÈíµÄºÏ×÷»ï°éÒÔ¼°Î¢ÈíµÄÊ×Ñ¡¾ÏúÉÌ£¬CyberSavvy Ëù¿ª·¢µÄ¶à¿îÓ¦ÓóÌÐò±»Î¢ÈíµÄÏúÊÛ¡¢Êг¡¡¢ÒÔ¼°ÆäËûÍŶÓËùʹÓá£
CyberSavvy Ëù¿ª·¢µÄÉÌÒµÖÇÄÜÓ¦ÓóÌÐòÐèҪͬÊý¾Ý¿â¼¯³É£¬¸Ã¹«Ë¾ÔÚÕâ·½Ãæ¾Ñé·á¸»£¬²¢ÇÒÏ£Íûͨ¹ý»ùÓÚ·þÎñµÄƽ̨À´¼ò»¯²¢×Ô¶¯»¯Êý¾Ý¿âÉè¼ÆºÍ²¿Ê𣬴Ӷø½µµÍ³É±¾¡£ÔÚʵÏÖÆä½â¾ö·½°¸µÄ¹ý³ÌÖУ¬×î´óµÄÌôÕ½ÊÇÈçºÎÈ·±£Êý¾ÝÔÚ·þÎñÆ÷Êý¾Ý¿âºÍ¿Í»§¶Ë×ÀÃæ»ú»òÒƶ¯É豸¼äͬ²½Ê±±£³ÖÍêÕûÐÔ£¬Í¬Ê±»¹ÐèÒª¿¼Âǵ½¶àÓû§µÄ²¢·¢Á¬½ÓÒÔ¼°ÍÑ»úÓû§¡£
×î³õ¸Ã¹«Ë¾»ùÓÚWeb ·þÎñÀ´´¦Àíͬ²½ÎÊÌ⣬µ«Ëæºó·¢ÏÖµ±¶Ô¸´ÔӵĹØϵÐÍÊý¾ÝÁ¬Ðø½øÐвåÈë/¸üÐÂ/ɾ³ý²Ù×÷ʱ£¬»á²úÉúºÜ¶àÎÊÌâ²¢ÇÒ²»Îȶ¨¡£Èç¹ûÈÎÒâÒ»¸ö²½Öè³öÏÖÎÊÌ⣬Ôò»áµ¼ÖÂÕû¸öͬ²½¹ý³ÌµÄʧ°Ü¡£µ±Óû§²ÉÓÃÍÑ»ú·½Ê½¹¤×÷ÁËÊýÌìÒÔºó£¬Ôٴγ¢ÊÔͬ²½Ê±£¬ÓпÉÄÜ»áÓÉÓÚÆäËù×÷µÄ¸ü¸ÄÒѾ±»ÆäËûÈËÔٴνøÐÐÁ˸üУ¬²¢×îÖÕµ¼ÖÂͬ²½Ê§°Ü£¬Õ⽫ʹµÃºóÐøµÄ²Ù×÷È«²¿Ê§°Ü¡£
ÔÚ¹«Ë¾Äܹ»Îª¿Í»§ÌṩÊý¾Ý·á¸»µÄ×Ô¶¯»¯½â¾ö·½°¸Ö®Ç°£¬ÐèÒªÄܹ»¸üºÃµÄÈ·±£Êý¾ÝÔÚÍøÂçÖеĴ«Êä¡£ÓÉÓڸù«Ë¾½«Êý¾Ý¿â×Ô¶¯»¯·þÎñ×÷ΪӦÓóÌÐòÀ´Ìṩ£¬Òò´ËÐèÒª¸üºÃµÄÉìËõÐÔ¡¢Ö§³Ö¸ü¶àµÄÊý¾ÝÀàÐÍ¡¢Ìṩ¸üºÃµÄ°²È«ÐԺͼÓÃܹ¦ÄÜ¡¢ÒÔ¼°Í¨¹ýÊý¾ÝѹËõÀ´¼õÉÙ±¸·ÝËùÐèµÄ¿Õ¼ä¡£
½â¾ö·½°¸
CyberSavvy ¿ª·¢ÁËDataPlace£¬¸Ã²úÆ·±»¹«Ë¾³Æ֮Ϊ“Êý¾Ý¿â¹¤³§”£¬Ëü¿ÉÒÔ½«ËùÓи´ÔÓµÄÁ÷³ÌÒÔ¼°Êý¾Ý¿â´´½¨Ê±µÄÉè¼Æ¹¤×÷½øÐÐ×Ô¶¯»¯£¬²¢ÔÚ²¿ÊðʱΪÍÑ»úÓû§²ÉÓÃSmart Clients. ¿Í»§ÃèÊöËûÃÇÏ£ÍûÓÃÊý¾Ý¿â×ö
Ïà¹ØÎĵµ£º
ÔÚ·Ö×éÅÅÐò¹ý³ÌÖÐÐèҪн¨ÅÅÐòÁУ¬°´Ìõ¼þ:(ÎïÁÏ·ÖÀà+¿Í»§Ãû³Æ) ½øÐзÖ×é»ã×Ü È»ºó¾Í¸ù¾Ý¸ÃÌõ¼þ½øÐÐÅÅÐò
1.ÐèҪƴ´ÕÁ½ÁÐ ×÷ΪÅÅÐòÁÐ,ÈçÐè¼ÓÈëÌØÊâ×Ö·û.¾Í»á±¨´í.
ÒòΪ±¾Éí¸Ä×ֶξÍÊÇvarcharÀàÐÍ ÐèÒª½«charÀàÐÍ'_' ת»»³Évarchar
2.Æ´´Õ¹ý³ÌÖÐÓпոñÐèҪȥ¿Õ¸ñ
e.g£ºselect (trim(ÎïÁÏ·ÖÀà)+to_char( ......
CREATE Table <±íÃû>
£¨[<ÁÐÃû1>] ÀàÐÍ (³¤¶È) [ȱʡֵ][Áм¶Ô¼Êø]
[£¬<ÁÐÃû2> Êý¾ÝÀàÐÍ[ȱʡֵ][Áм¶Ô¼Êø]]….
[£¬UNIQUE£¨ÁÐÃû[£¬ÁÐÃû]….£©]
[£¬PRIMARY KEY£¨ÁÐÃû[£¬ÁÐÃû]…£©]
&n ......
==============================================
µÚ1½²
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk1389
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk1389.zip
µÚ2½²
ÔÚÏß¹Û¿´£º http://www.boobooke.com/v/bbk1390
ÊÓƵÏÂÔØ£º http://www.boobooke.com/v/bbk1390.zip
µÚ3½²
ÔÚÏß¹Û¿´£º http ......
¡¾ÔÎĵØÖ·¡¿Tip/Trick: Guard Against SQL Injection Attacks
¡¾ÔÎÄ·¢±íÈÕÆÚ¡¿ Saturday, September 30, 2006 9:11 AM
SQL×¢Èë¹¥»÷ÊǷdz£ÁîÈËÌÖÑáµÄ°²È«Â©¶´£¬ÊÇËùÓеÄweb¿ª·¢ÈËÔ±£¬²»¹ÜÊÇʲôƽ̨£¬¼¼Êõ£¬»¹ÊÇÊý¾Ý²ã£¬ÐèҪȷÐÅËûÃÇÀí½âºÍ·ÀÖ¹µÄ¶«Î÷¡£²»ÐÒµÄÊÇ£¬¿ª·¢ÈËÔ±ÍùÍù²»¼¯Öл¨µãʱ¼äÔÚÕâÉÏÃ棬ÒÔÖÁËûÃǵÄÓ¦Ó㬠......
----start
ÎÊÌ⣺²é¿´DB2 °æ±¾---SELECT * from SYSIBM.SYSVERSIONS
ÎÊÌ⣺²é¿´ÏµÍ³ÖÐÓÐÄÄЩ±íÒÔ¼°ÕâЩ±íµÄ¸ÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.TABLES
ÎÊÌ⣺²é¿´Ä³¸ö±íÓÐÄÄЩÁÐÒÔ¼°ÕâЩÁеĸÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.COLUMNS WHERE TABNAME=<YOUR_TABLE_NAME>
---´ýÐøδÍê
---¸ü¶à²Î¼û£ºDB2 SQL ¾«Ò ......