SQL Server 2008 °¸Àý֮΢ÈíIT²¿ÃÅ
“¾¹ý²âÊÔÎÒÃÇ·¢ÏÖSQL Server 2008µ±Öеı¸·ÝѹËõ¹¦ÄÜ¿ÉÒÔ1-3±¶µÄѹËõ±È£¬´Ó¶ø¼«´óµÄ¼õÉÙ±¸·ÝËùÐèµÄ´ÅÅ̿ռ䡣”Alexey Yeltsov, ΢Èíϵͳ¹ÜÀíÔ±Ö÷¹Ü¡£
΢ÈíÔÚÈ«ÊÀ½ç¹²ÓÐ6Íò¶àÃûÔ±¹¤£¬ÔÚ2006ÄêµÄ²ÆÕþÊÕÈ볬¹ýÁË500ÒÚÃÀ½ð£¬Óë´ËͬʱҲ²úÉúÁË´óÁ¿ÄÚ²¿Êý¾Ý£¬¹«Ë¾Ï£Íû¶ÔÕâЩÊý¾Ý½øÐм¯ÖÐÒÔ±ãÌṩ¿Í»§µÄ¼¯³É»¯ÊÓͼ¡£ÎªÁËÍê³É¸ÃÈÎÎñ£¬Î¢ÈíµÄIT ²¿ÃŲÉÓÃ΢ÈíÓ¦ÓóÌÐòƽ̨£¬ÀûÓÃMicrosoft SQL Server® 2008À´´´½¨ÆóÒµ¼¶Êý¾Ý²Ö¿â£¨EDW£©£¬²¢½«ÆäÔËÐÐÔÚWindows Server® 2008 ÆóÒµ°æ²Ù×÷ϵͳ֮ÉÏ¡£EDW ÖеÄÊý¾ÝÁ¿ÒѾ´ïµ½ÁË2.5TB ²¢ÇÒÔÚ²¿ÊðºóµÄ12¸öÔÂÄÚÔ¤¼Æ½«´ïµ½10TB£¬´Ó¶ø°ïÖú¹«Ë¾¸üºÃµÄÁ˽â¿Í»§¡£IT ²¿ÃÅ·¢ÏÖÀûÓÃSQL Server 2008µÄ±¸·ÝѹËõ¹¦ÄÜ£¬¿ÉÒÔ½ÚÔ¼1/3µÄ±¸·Ý´æ´¢¿Õ¼ä¡£Î¢Èí¹«Ë¾Í¬Ê±»¹ÏíÊܵ½ÁËSQL Server 2008Öмò»¯µÄÊý¾Ý¹ÜÀí¹¦ÄÜ¡£
Çé¿ö
΢Èí¹«Ë¾ÔÚÈ«ÊÀ½ç89¸ö¹ú¼Ò¾ùÓа칫ÊÒ£¬ÊÇÊÀ½çÉÏ×î´óµÄÈí¼þ¹«Ë¾£¬2006ÄêµÄ²ÆÕþÊÕÈ볬¹ýÁË500ÒÚÃÀ½ð¡£ÈçͬÆäËü´óÐÍÆóÒµÒ»Ñù£¬¸Ã¹«Ë¾ÐèÒªÊý¾Ý´æ´¢¿âÀ´¸üºÃµÄ¸ú×ÙÆäÒµÎñ²¢·ÖÎö¿Í»§ÐèÇó¡£
΢Èí¹«Ë¾µÄÔ±¹¤ÊýÁ¿³¬¹ýÁË6ÍòÃû£¬²¢ÇÒÒѾӵÓÐÁËÊý¾Ý²Ö¿â¡¢Êý¾ÝÊг¡¡¢ÒÔ¼°ÆäËü´æ´¢¿âÔÚ¹«Ë¾ÄÚ²¿À´Ö§³Ö±¨±íºÍ·ÖÎöÒÔ¼°ÆäËü¹¦ÄÜ£¬ÀýÈçFeedStore Êý¾Ý¿â — Èç´ËÃüÃûÊÇÒòΪËü¿ÉÒÔ´Ó39¸öÄÚ²¿Ô´ÖлñµÃÊý¾Ý²¢½«ÕâЩÊý¾Ý·¢Ë͸ø500¸öÓÃÓÚ¶©ÔĵÄÄÚ²¿Ó¦ÓóÌÐò¡£
΢ÈíµÄIT ²¿ÃÅÐèÒª´´½¨¼¯Öл¯µÄÊý¾Ý´æ´¢¿âÀ´´ÓCRMϵͳ¡¢²ÆÎñÓ¦ÓóÌÐò¡¢ÒÔ¼°Ò»ÏµÁÐÆäËüÊý¾ÝÔ´ÖлñÈ¡ÐÅÏ¢£¬´Ó¶ø´´½¨ÆóÒµ¼¶Êý¾Ý²Ö¿â£¨EDW£©
“ÎÒÃÇÐèÒªÆóÒµ¼¶µÄÊý¾Ý²Ö¿âÀ´ÕæÕýµÄ½«¿Í»§Í¬¹«Ë¾ÆäËüÊý¾Ý²Ö¿â¼°´æ´¢¿âÖеIJÆÎñÊý¾Ý¼¯³Éµ½Ò»Æð¡££¬”΢ÈíIT ²¿ÃÅÉÌÒµÖÇÄÜ×ܾÀíJim Walch½âÊ͵À£¬“ÀûÓÃ΢ÈíÓ¦ÓóÌÐòƽ̨À´´´½¨EDW ÊÇÎÒÃÇΪ¿Í»§ÌṩÕû¸öÆóÒµÐÅÏ¢Ò»ÖÂÐÔÊÓͼµÄΨһѡÔñ¡£Î¢ÈíIT ²¿ÃŵÄEDW ´´½¨ÁËÒ»¸öÍêÃÀµÄƽ̨£¬¿ÉÒÔÈÃÎÒÃǵÄÓû§ÀûÓÃQL Server® Reporting Services, SQL Server Analysis Services, Performance Point Server, ÒÔ¼°Office ExcelµÈ¹¤¾ßÀ´·ÖÎöÊý¾Ý¡£”
½â¾ö·½°¸
¹«Ë¾²ÉÓÃMicrosoft SQL Server 2008 ÆóÒµ°æ×÷ΪÊý¾Ý¿âÈí¼þ£¬²¢²ÉÓÃWindows Server® 2008ÆóÒµ°æ×÷Ϊ²Ù×÷ϵͳ£¬¹¹½¨ÁËÆóÒµ¼¶Êý¾Ý²Ö¿â¡£¹«Ë¾ÐèÒª¼á¹ÌµÄÊý¾Ý¿âÀ´Ö§³Ö2.5TBµÄÊý¾Ý²¢ÔÚ²¿ÊðºóµÄ12¸öÔÂÄÚÄܹ»³É¹¦À©Õ¹µ½10TB¡£
EDW ÖаüÀ¨À´×ÔFeedStore Êý¾Ý¿âÖеÄÊý¾Ý£¬Í¬Ê±´ÓһϵÁÐÆäËüÊý¾ÝÔ´ÖÐÌí¼ÓÐÅÏ¢£¬ÕâЩÊý¾ÝÔ´°üÀ¨Microsoft Accounting Re
Ïà¹ØÎĵµ£º
Ò»¡¢¼òµ¥²éѯ
¡¡¡¡ ¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣
ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ
±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
SELECT nickname,email
from testtable WHERE name='ÕÅÈý'
(Ò»)Ñ¡ÔñÁбí
¡ ......
String keyword = request.getParameter("keyword");
String timeRange = request.getParameter("timeRange");
String type = request.getParameter("type");
StringBuffer sql = new StringBuffer();
sql.append("use webstation_leadall s ......
MS SQL SERVER 2005È«ÎÄË÷Òýѧϰ±Ê¼ÇÒ»
ÏÈÁ˽âÒ»ÏÂÈ«ÎÄË÷ÒýÊÇÈçºÎ´´½¨ºÍʹÓõÄ
´´½¨È«ÎÄË÷Òý:
ÔÚMS SQL SERVER 2005Àï,È«ÎÄË÷ÒýÊÇÒ»¸öµ¥¶ÀµÄ·þÎñÏî,ĬÈÏÊÇÆô¶¯µÄ,µ«ÊÇûÓÐÔÊÐíÊý¾Ý¿âÆôÓÃÈ«ÎÄË÷Òý,Èç¹ûÒ ......
¹Ø¼ü×Ö: oracle & sql server
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö· ......
----start
ÎÊÌ⣺²é¿´DB2 °æ±¾---SELECT * from SYSIBM.SYSVERSIONS
ÎÊÌ⣺²é¿´ÏµÍ³ÖÐÓÐÄÄЩ±íÒÔ¼°ÕâЩ±íµÄ¸ÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.TABLES
ÎÊÌ⣺²é¿´Ä³¸ö±íÓÐÄÄЩÁÐÒÔ¼°ÕâЩÁеĸÅÒªÐÅÏ¢£ºSELECT * from SYSCAT.COLUMNS WHERE TABNAME=<YOUR_TABLE_NAME>
---´ýÐøδÍê
---¸ü¶à²Î¼û£ºDB2 SQL ¾«Ò ......