Microsoft SQL Azure ³£¼ûÎÊÌâ½â´ð
¹«¸æ£º±¾²©¿ÍΪ΢ÈíÔÆ¼ÆËãÖÐÎIJ©¿ÍµÄ¾µÏñ²©¿Í£¬²¢²»±£Ö¤Á´½Ó¿ÉÓÃÐÔ£¬ÎªÁ˱£Ö¤ÔĶÁÌåÑ飬Çë·ÃÎÊhttp://blogs.msdn.com/azchina¡£
October CTPµÄ SQL Azure DatabaseµÄ¹Ø¼ü¹«¸æÊÇʲô£¿
October CTPµÄSQL Azure database¶ÔÓÚPDC2009À´Ëµ»ù±¾¹¦ÄÜÒѾÍê³ÉÁË¡£ October CTP ÒѾ±»²¿ÊðÖÁÉú²ú¼¯ÈºÖ®Ò»¡£µ±SQL Azure Database±äΪ¹ã·º¿ÉÓ㬴˻·¾³»á×Ô¶¯×ª±äΪһ¸öÊܵ½Íêȫ֧³ÖµÄÉú²ú»·¾³¡£»ùÓÚÄúËùÑ¡ÔñµÄSQL Azure databaseÈϹº·½Ê½£¬ÄúËùÓÐÔÚ´Ë»·¾³ÖеÄÊý¾Ý¿âÓëÊý¾Ý»á±»×ª»»ÎªÒ»¸öÓÐЧÈϹºµÄ״̬¡£
SQL Azure Database°üÀ¨ÄÄЩÐÂÌØÐÔ£¿
October CTPµÄSQL Azure database¶ÔÓÚPDC2009À´Ëµ»ù±¾¹¦ÄÜÒѾÍê³ÉÁË¡£ÔÚOctober CTPÖеÄһЩÐÂÌØÐÔ°üÀ¨£¨·À»ðǽ֧³Ö£¬ÅúÁ¿²åÈ룬ÊôÐÔ¸ü¸Ä£¬ÃÅ»§ÍøÕ¾£¬¶îÍâµÄTSQL¹¦ÄÜ£©¡£¸ü¶àÏêϸÐÅÏ¢Çëä¯ÀÀBlog post¡£
ʲôÊÇSQL Azure Data Sync?
SQL Azure Data Sync ÊÇÒ»¸ö¹¤¾ßÓëÔËÐÐʱ£¬ÓÃÀ´ÓëSQL Azureͬ²½¡£¸Ã¼¼ÊõÔÚÄܹ»ÔËÓÃÓÚ2¸ö·½°¸£¨ÔÚÆäËûÔÆÆ½Ì¨ÔÝÎÞͬÀ༼Êõ£©£º½«·ÇÔÆ¶ËµÄ»ù´¡Éèʩͬ²½ÖÁÔÆ¶Ë£¬¹¹½¨¾ßÓÐÀëÏߣ¨»º´æÄ£Ê½£©Ö§³ÖµÄ¿Í»§¶Ë¡£½«·ÇÔÆ¶ËµÄ»ù´¡¹¹½¨Í¬²½ÖÁÔÆ¶Ë£¬Í¨¹ýʹÓÃÔÆ¶ËµÄзþÎñÄܹ»ÈÃÐÅÏ¢ÔÚÊÖ»úÓû§¡¢ÉÌÒµ»ï°é¡¢Ô¶³Ì°ì¹«¡¢ÆóÒµÊý¾Ý×ÊÔ´Ö®¼ä¸ü¼ò±ãµÄ±»¹²Ïí¡£ÕâÏî¼¼ÊõÌṩÁËÒ»¸öÇÅÁº£¬ÔÊÐí·ÇÔÆ¶ËÓëÔÆ¶ËµÄÓ¦ÓóÌÐòͬʱ¹¤×÷¡£Ê¹Óûº´æÄ£Ê½£¬µÍÑÓ³ÙÓë¸ß¿ÉÓÃÐÔʹµÃÄܹ»¿ª·¢³ö¾ßÓÐÓÅÐãÓû§ÌåÑéµÄ¿Í»§¶Ë¡£ÁíÍ⣬»º´æÄ£Ê½Í¨¹ýµÍ¸ººÉÒÔ¼°¸ü¼ÓÓÅÐãµÄµ÷¶ÈÄÜÁ¦£¬ÌṩÁ˸üµÍµÄÍøÂçʹÓÃÂÊÓë¸üºÃµÄ·þÎñÆ÷¹æÄ£µÄºÃ´¦¡£
ÎÒÈçºÎµÃµ½SQL Azure Data Sync¸ü¶àÏêϸÐÅÏ¢£¿
ÔÚPDC 2009»áÒéÉÏ£¬SQL Azure Data Sync×÷ΪCTP°æ±¾ÔÚ´ËÁ´½ÓMicrosoft Sync Framework Power Pack for SQL Azure¿ÉÏÂÔØµ½¡£ÈçÐè»ñµÃ¸ü¶àÐÅÏ¢£¬Çë·ÃÎÊhttp://www.microsoft.com/windowsazure/sqlazure/datasync¡£SQL Azure CTP ²¢²»°üÀ¨Microsoft Sync Framework Power Pack for SQL Azure,ËüÐèÒª¶ÀÁ¢ÏÂÔØ¡£
ʲôÊǶÔÓÚ»ùÓÚSOAPºÍRESTµÄAuthority-Container-Entity (ACE) ±à³ÌģʽµÄ·ÃÎÊ£¿
Ëæ×ÅÇ¨ÒÆÖÁ»ùÓÚT-SQLµÄ¹ØÏµÐÍÊý¾Ý¿âģʽ£¬SQL Azure Database ²»»áÖ§³Ö»ùÓÚSOAPºÍRESTµÄ Authority-Container-Entity (ACE)µÄ±à³Ìģʽ¡£»ùÓÚ´óÁ¿ÔçÆÚʹÓõĿͻ§Óë»ï°éµÄ·´À¡£¬´ó¶àÊý¿Í»§»
Ïà¹ØÎĵµ£º
±¾ÎĹؼü´Ê£ºSQL 2008 SQL SQL Server SQL Server 2008
¶ÔÓÚ¼´½«ÔÚ2008ÄêÂ¡ÖØ·¢²¼µÄSQL Server 2008£¬Î¢ÈíÆÚÍûÊг¡²»½ö½öÊǰÑËü×÷Ϊ¹ØÏµÊý¾Ý¿âϵͳÀ´¿´´ý£¬Î¢Èí½«Æä¶¨Î»ÎªÒ»¸öÆóÒµÊý¾Ýƽ̨£¬ËäÈ»¹ØÏµÊý¾Ý¿âÒýÇæÈÔÈ»ÊÇSQL Server 2008µÄºËÐÄ£¬²»¹ýSQL Server 2008ËùÄÜÌṩµÄ·þÎñ¹ã¶È½«Ô¶³¬¹ý¼òµ¥µÄ¹ØÏµÊý¾ ......
¼Æ»®ÓÚ2008ÄêµÚÒ»¼¾¶È·¢²¼µÄSQL Server 2008²»½ö¶ÔÔÓÐÐÔÄܽøÐÐÁ˸Ľø£¬»¹Ìí¼ÓÁËÐí¶àÐÂÌØÐÔ£¬±ÈÈçÐÂÌíÁËÊý¾Ý¼¯³É¹¦ÄÜ£¬¸Ä½øÁË·ÖÎö·þÎñ£¬±¨¸æ·þÎñ£¬ÒÔ¼°Office¼¯³ÉµÈµÈ¡£
¡¡¡¡SQL Server¼¯³É·þÎñ
¡¡¡¡SSIS(SQL Server¼¯³É·þÎñ)ÊÇÒ»¸öǶÈëʽӦÓóÌÐò£¬ÓÃÓÚ¿ª·¢ºÍÖ´ÐÐETL(½âѹËõ¡¢×ª»»ºÍ¼ÓÔØ)°ü¡£SSIS´úÌæÁËSQL 2000µÄDTS¡£Õ ......
SQL Server2008ÐÐÊý¾ÝºÍÒ³Êý¾ÝѹËõ½âÃÜ
Êý¾ÝѹËõÒâζ׿õСÊý¾ÝµÄÓдÅÅÌÕ¼ÓÃÁ¿£¬ËùÒÔÊý¾ÝѹËõ¿ÉÒÔÓÃÔÚ±í£¬¾Û¼¯Ë÷Òý£¬·Ç¾Û¼¯Ë÷Òý£¬ÊÓͼË÷Òý»òÊÇ·ÖÇø±í£¬·ÖÇøË÷ÒýÉÏ¡£2.ǰ±êѹËõ£ºÃ¿Ò»Ò³ÖеÄËùÓÐÁУ¬ÔÚÐбêÍ·ÏÂÃæ£¬Ã¿Ðж¼´æ´¢×ÅÒ»¸öÐж¨ÒåÖµ£¬Ñ¹Ëõºó£¬ËùÓÐÐе͍ÒåÖµ¶¼±»Ìæ»»³ÉÐÐÍ·ÖµµÄÒýÓá£
¡¡¡¡±¾ÎĽ«Îª´ó¼Ò½éÉÜ ......
¸ñʽ:
CONVERT(data_type,expression[,style])
˵Ã÷:
´ËÑùʽһ°ãÔÚʱ¼äÀàÐÍ(datetime,smalldatetime)Óë×Ö·û´®ÀàÐÍ(nchar,nvarchar,char,varchar)
Ï໥ת»»µÄʱºò²ÅÓõ½.
Àý×Ó:
SELECT CONVERT(varchar(30),getdate(),101) now
½á¹ûΪ:
now
---------------------------------------
|09/15/2001
=============== ......