SQL½Å±¾×Ö¶Î[content]ºÍcontentÇø±ð
½ñÌìÎÒÔÚSQL Server 2005ÖÐÓýű¾´´½¨Ò»ÕÅ±í£¬²é×ÊÁÏ·¢ÏÖÓеĽű¾ÖÐ×Ö¶ÎÓмÓ[]ÖзûºÅ£¬ÎÒÎÊÁ˶¬¼¾£¬µÃÖªÊÇÕâ»ØÊ£¬ÓÃ[]µÄ×Ö¶ÎÃû£¬¼´±ãÊÇsql¹Ø¼ü×ÖÒ²¿ÉÒÔ×÷Ϊ×Ö¶ÎÃû£¬²»»á±¨´í¡£
SQL ServerÀïµÄ±íÖÐÌí¼ÓÒ»¸ö×ֶΣ¬È磺timeϵͳ»á×Ô¶¯¼ÓÒ»¶Ô·½À¨ºÅ¼´£º[time]£¬»¹ÓÐÌí¼ÓÁíÒ»¸ö×Ö¶ÎSUMÒ²ÊÇÕâÑùµÄ£¬»á±ä³É[SUM]¡£
ÕâÊÇÒòΪ×Ö¶ÎÃûÊÇϵͳ±£Áô×Ö,Èç¹ûÒªÓÃÕâЩ±£Áô×Ö,±ØÐëÓÃ[]»òÕßÒýºÅ½«ËüÒýÆðÀ´£¬ÍƼö×Ö¶Î×îºÃ²»ÒªÓñ£Áô×Ö¡£
Ïà¹ØÎĵµ£º
Èç¹ûÄúÔÚ°²×°SQL Server 2005ʱ³öÏÖ¼ÆÊýÆ÷´íÎó
µã»÷¿ªÊ¼£ÔËÐÐÊäÈë"cmd"£¬È·¶¨ºó½øÈëÃüÁî´°¿Ú£¬ÒÀ´ÎÊäÈëÏÂÃæ4ÌõÃüÁîɾ³ý4¸ö¼ÆÊýÆ÷£º
unlodctr w3svc
unlodctr msftpsvc
unlodctr asp
unlodctr inetinfo
È»ºóÔÙÒÀ´ÎÊäÈëÏÂÃæ4ÌõÃüÁî֨װ4¸ö¼ÆÊýÆ÷£º
lodctr w3ctrs.ini
lodctr ftpctrs.ini
lodctr axperf.ini
lod ......
³õ¼¶Æª —— ¼òµ¥²éѯÓï¾äµÄµ÷ÓÅ ÀîÃ÷»Û , Èí¼þ¹¤³Ìʦ, IBM
ÀîÃ÷»Û£¬ÔÚ IBM ÖйúÈí¼þ¿ª·¢ÖÐÐÄ Data Studio ÍŶӹ¤×÷´ÓÊ InfoSphere Warehouse Administration Console µÄ¹¦ÄܲâÊÔ¹¤×÷¡£ÔøÔÚ developerWorks ·¢±í¡¶½« DB2 DWE 9.1.X Ç¨ÒÆµ½ DB2 Warehouse 9.5¡·¡¢¡¶InfoSphere Warehouse SQL ²Ö´¢ÃüÁîÐнӿ ......
private void Create_Pz(string Sourcename)
{
string OutMsg;
SqlParameter[] sortPara = { new SqlParameter("@ps_IsType", Pz ......
1.ʹÓÃManagement Studio Express£¬ÓÓWindowsÉí·ÝÑéÖ¤”µÇ¼£¬Ñ¡ÖÐSQL·þÎñÆ÷Ãû£¬ÓÒ»÷Êó±êÑ¡ÔñÊôÐÔ£¬ÔÚ·þÎñÆ÷ÊôÐÔÑ¡ÏîÒ³Ãæ£¬Ñ¡Ôñ“°²È«ÐÔ”£¬½«·þÎñÆ÷Éí·ÝÑéÖ¤ÓÉ “WindowsÉí·ÝÑéÖ¤”¸ÄΪ“SQL ServerºÍWindowsÉí·ÝÑéÖ¤”£¬µ¥»÷È·¶¨¡£
2.ʹÓÃSQL Server 2005ÍâΧӦÓÃÅäÖÃÆ÷£¬Ñ¡ ......