Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Windows Azureƽ̨¼ò½é(ËÄ)£ºSQL AzureÒÔ¼°ÆäËû·þÎñ


¹«¸æ£º±¾²©¿ÍΪ΢ÈíÔÆ¼ÆËãÖÐÎIJ©¿ÍµÄ¾µÏñ²©¿Í£¬²¢²»±£Ö¤Á´½Ó¿ÉÓÃÐÔ£¬ÎªÁ˱£Ö¤ÔĶÁÌåÑ飬Çë·ÃÎÊhttp://blogs.msdn.com/azchina¡£
 
 
SQL AzureÊÇÒ»¸ö²¿ÊðÔÚÔÆ¶ËµÄ¹ØÏµÐÍÊý¾Ý¿âÒýÇæ£¬ËüÖ§³ÖSQL ServerÖоø´ó¶àÊýºÍ¿ª·¢ÓйصŦÄÜ¡£×÷Ϊһ¸ö²¿ÊðÔÚÔÆ¶ËµÄÊý¾Ý¿âÒýÇæ£¬¾ø´ó¶àÊýµÄ¹ÜÀí¹¤×÷¶¼ÓÉ΢ÈíΪÄãÍê³É£¬Òò´ËÄã²»Óõ£ÐÄÈκÎÖîÈ籸·Ý£¬¼¯Èº£¬µÈ¹ÜÀí·½ÃæµÄÎÊÌ⣬ÎÒÃǵÄSLA (Service Level Agreement)È·±£ÁËÄãµÄÊý¾Ý¿â·þÎñÆ÷ƽ¾ùÿ¸öÔ½«ÓÐ99.99%µÄʱ¼äÔÚÏß¡£Ò²ÕýÊÇÒòΪÕâµã£¬Ä¿Ç°ÎÒÃÇÔÝʱûÓб©Â¶Ì«¶àµÄ¹ÜÀí¹¦ÄܸøÓû§¡£
¿ª·¢ÈËÔ±¿ÉÒÔʹÓÃÏÖÓеÄ֪ʶ£¬ÀýÈçADO.NET Entity Framework (EDM)£¬LINQ to SQL£¬ÉõÖÁÊÇ´«Í³µÄDataSet£¬ODBCµÈ¼¼Êõ£¬À´·ÃÎÊλÓÚSQL AzureÉϵÄÊý¾Ý¡£¾ø´ó¶àÊýÏÖÓеÄÊý¾Ý·ÃÎʳÌÐòÖ»ÐèÒªÐÞ¸ÄÒ»¸öÁ¬½Ó×Ö·û´®£¬±ãÄÜ˳Àû·ÃÎÊSQL Azure¡£
SQL Server 2008 Management Studio R2£¨Ä¿Ç°ÎªCTP°æ±¾£©Õë¶ÔSQL AzureÒ²ÌṩÁ˺ÜÇ¿´óµÄÖ§³Ö¡£Ä¿Ç°µÄCTP°æ±¾ÒѾ­Ö§³Ö¸ù¾ÝÏÖÓеÄÊý¾Ý¿â£¬Éú³ÉÄÜÔÚSQL AzureÉÏÔËÐеÄT-SQL½Å±¾£¬´Ó¶ø·½±ã´ó¼Ò½«Êý¾Ý¿âÇ¨ÒÆÖÁSQL Azure¡£½ñºóµÄ°æ±¾Öлá¶ÔSQL AzureÌṩ¸ü¶à¸üÇ¿´óµÄÖ§³Ö¡£
ÆäËû
Windows Azureƽ̨»¹»áÍÆ³ö¸ü¶àµÄ·þÎñ¹©´ó¼ÒʹÓá£ÀýÈ磬ÏÖÔÚ´¦ÓÚCTP½×¶ÎµÄDallas£¬¾ÍÊÇÒ»¸ö²¿ÊðÔÚÔÆ¶ËµÄÊý¾Ý·ÖÎö·þÎñ¡£ËüÖ§³ÖºÍ³£ÓõŤ¾ß£¨ÀýÈçExcel 2010µÄPowerPivot£©½áºÏÆðÀ´Ê¹Ó㬴ӶøÈÃÓû§Äܹ»Ê¹ÓÃ×Ô¼ºËùÊìϤµÄ¹¤¾ßÀ´·ÖÎöλÓÚÔÆ¶ËµÄÊý¾Ý¡£


Ïà¹ØÎĵµ£º

sqlÓï¾äÓÅ»¯30Àý×Ó

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ ......

´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦




¿Í»§Ãû³Æ
´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦


Êý¾Ý¿â°æ±¾
SQL SERVER 2008


Îļþ´óС
5G


¹ÊÕÏÃèÊö
¿Í»§µÄÓÎÏ··þ ......

SQL Server 2008³É¾ÍÆóÒµÊý¾Ýƽ̨

 
 
±¾ÎĹؼü´Ê£ºSQL 2008 SQL SQL Server SQL Server 2008
¶ÔÓÚ¼´½«ÔÚ2008ÄêÂ¡ÖØ·¢²¼µÄSQL Server 2008£¬Î¢ÈíÆÚÍûÊг¡²»½ö½öÊǰÑËü×÷Ϊ¹ØÏµÊý¾Ý¿âϵͳÀ´¿´´ý£¬Î¢Èí½«Æä¶¨Î»ÎªÒ»¸öÆóÒµÊý¾Ýƽ̨£¬ËäÈ»¹ØÏµÊý¾Ý¿âÒýÇæÈÔÈ»ÊÇSQL Server 2008µÄºËÐÄ£¬²»¹ýSQL Server 2008ËùÄÜÌṩµÄ·þÎñ¹ã¶È½«Ô¶³¬¹ý¼òµ¥µÄ¹ØÏµÊý¾ ......

SQL Server JDBC Çý¶¯·â×°

1¡¢½¨Á¢Ò»¸öjdbc.jsp Îļþ£º
2¡¢½«ÏÂÃæÏàÓ¦µÄ´úÂë¸´ÖÆµ½jdbc.jspÖÐ
3¡¢±àдҪÁ¬½Óµ½Êý¾Ý¿âµÄjspÎļþʱ£¬Ö»Ð轫jdbc.jspÎļþ°üº¬µ½¸ÃjspÎļþÖоÍÐÐÁË
·½·¨£ºÌí¼Ó<%@  include file="jdbc.jsp">µ½jspÎļþÖм´¿É
//sql server2005:
<%@ page language="java" import ="java.util.*"%>
 
<%
& ......

asp.netÁ¬½ÓSQL ºÍACCESSÊý¾Ý¿â

ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â 
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë: 
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ