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. ¿Í»§ÃèÊöËûÃÇÏ£ÍûÓÃÊý¾Ý¿â×ö
Ïà¹ØÎĵµ£º
ÕÆÎÕSQLËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä£ºInsert£¬Select£¬UpdateºÍDelete¡£
¡¡¡¡ Á·ÕÆÎÕSQLÊÇÊý¾Ý¿âÓû§µÄ±¦¹ó²Æ ¸»¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Òýµ¼ÄãÕÆÎÕËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä—SQLµÄºËÐŦÄÜ—À´ÒÀ´Î½éÉܱȽϲÙ×÷·û¡¢Ñ¡Ôñ¶ÏÑÔÒÔ¼°ÈýÖµÂß¼¡£µ±ÄãÍê³ÉÕâЩѧϰºó£¬ÏÔÈ»ÄãÒѾ¿ªÊ¼ËãÊǾ«Í¨SQLÁË¡£
¡¡¡¡ÔÚÎÒÃÇ¿ªÊ¼Ö®Ç°£¬ÏÈ ......
if exists(select 1 from sysobjects where name='char_index')
drop function char_index
create function char_index(@string varchar(8000),@char varchar(10),@index smallint)
--@string:´ý²éÕÒ×Ö·û´®£¬@index:²éÕÒλÖÃ
returns smallint
as
begin
declare
@i tinyint,--µ±Ç°ÕÒµ½µÚ@i¸ö
  ......
CREATE Table <±íÃû>
£¨[<ÁÐÃû1>] ÀàÐÍ (³¤¶È) [ȱʡֵ][Áм¶Ô¼Êø]
[£¬<ÁÐÃû2> Êý¾ÝÀàÐÍ[ȱʡֵ][Áм¶Ô¼Êø]]….
[£¬UNIQUE£¨ÁÐÃû[£¬ÁÐÃû]….£©]
[£¬PRIMARY KEY£¨ÁÐÃû[£¬ÁÐÃû]…£©]
&n ......
ÕªÒª£ºSQL Server 2008ÖÐÌṩÁË9ÖÖ³£ÓõÄÊý¾ÝÍÚ¾òËã·¨£¬ÕâЩËã·¨ÓÃÔÚ²»Í¬Êý¾ÝÍÚ¾òµÄÓ¦Óó¡¾°Ï£¬±¾Îľ͸÷¸öËã·¨Öð¸ö·ÖÎöÌÖÂÛ¡£
±êÇ©£ºÊý¾ÝÍÚ¾òËã·¨ SQL Server 2008
1.¾ö²ßÊ÷Ëã·¨
¾ö²ßÊ÷£¬ÓÖ³ÆÅж¨Ê÷£¬ÊÇÒ»ÖÖÀàËƶþ²æÊ÷»ò¶à²æÊ÷µÄÊ÷½á¹¹¡£¾ö²ßÊ÷ÊÇÓÃÑù±¾µÄÊôÐÔ×÷Ϊ½áµã£¬ÓÃÊôÐÔµÄÈ¡Öµ×÷Ϊ·ÖÖ§£¬Ò²¾ÍÊÇÀàËÆÁ ......