sql°²×°µÄÎÊÌ⣿£¿
°²×°sql server 2000µÄʱºò±¨´í£º¡°°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍ C:\WINDOWS\sqlstp.log Á˽â¸ü¶àÐÅÏ¢¡±
´ò¿ªsqlstp.logÎļþÖÐÄÚÈÝÈçÏ£º
ÕýÔÚÆô¶¯?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
ÕýÔÚÓë·þÎñ?
driver={sql server};server=GY;UID=sa;PWD=;database=master
[Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´
driver={sql server};server=GY;UID=sa;PWD=;database=master
[Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´
driver={sql server};server=GY;UID=sa;PWD=;database=master
[Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´
SQL Server ÅäÖÃ?
###############################################################################
23:09:20 Process Exit Code: (-1)
23:16:56 °²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍ C:\WINDOWS\sqlstp.log Á˽â¸ü¶àÐÅÏ¢¡£
23:16:56 Action CleanUpInstall:
23:16:56 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
23:16:56 Process Exit Code: (1060) Ö¸¶¨µÄ·þÎñ²¢Î´ÒÔÒѰ²×°µÄ·þÎñ´æÔÚ¡£
23:16:56 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
23:16:56 Process Exit Code: (0)
23:16:56 StatsGenerate returned: 2
23:16:56 StatsGenerate (0x0,0x1,0xf000000,0x200,2052,303,0x0,0x1,0,0,0
23:16:56 StatsGenerate -1,Administrator)
23:16:56
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
±íA
Sup_code st_sup_code buy_code buy_code1
1001 400 &nbs ......
Çé¿öÊÇÒ»Õűí(T)ÄÚ£¬Ã¿Ìõ¼Ç¼ÓÐÒ»¸öÀàÐÍ×ֶΣ¬µ±°´ÀàÐÍ×Ö¶ÎÀ´·ÖÀà²éѯ²¢·ÖÒ³´¦Àíʱ
(±íTÄÚµÄÀàÐÍÊÇÖ¸ÏòÁíÒ»ÕÅÀàÐͱíµÄÒ»¸öIDÖµ)
ÎÒÏëµ½ÁËÁ½ÖÖ·½Ê½£»
»·¾³£ºPHP+MYSQL
1¡¢PHP ÏÈÖ´ÐÐÒ»Ìõ²éѯµÃµ½ ......