sql 2000 ¸öÈ˰氲װÎÊÌâ
###############################################################################
ÕýÔÚÆô¶¯?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
ÕýÔÚÓë·þÎñ?
driver={sql server};server=;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server Éϲ»Ö§
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
driver={sql server};server=;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server Éϲ»Ö§
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
driver={sql server};server=;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server Éϲ»Ö§
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (PreLoginHandshake()).
SQL Server ÅäÖÃ?
###############################################################################
15:51:16 Process Exit Code: (-1)
15:52:47 °²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍ C:\WINDOWS\sqlstp.log Á˽â¸ü¶àÐÅÏ¢¡£
15:52:47 Action CleanUpInstall:
15:52:47 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
15:52:47 Process Exit Code: (1060) Ö¸¶¨µÄ·þÎñ²¢Î´ÒÔÒѰ²×°µÄ·þÎñ´æÔÚ¡£
15:52:47 C:\W
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN
¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª
ÐÕÃû ¿ÆÄ¿ ³É¼¨
ÕÅÈý Ó¢Óï 90
ÀîËÄ Ó¢Óï&nb ......