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

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


Ïà¹ØÎÊ´ð£º

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......

Á½ÖÖSQLÓï¾ä ЧÂÊÎÊÌâ

Çé¿öÊÇÒ»Õűí(T)ÄÚ£¬Ã¿Ìõ¼Ç¼ÓÐÒ»¸öÀàÐÍ×ֶΣ¬µ±°´ÀàÐÍ×Ö¶ÎÀ´·ÖÀà²éѯ²¢·ÖÒ³´¦Àíʱ
(±íTÄÚµÄÀàÐÍÊÇÖ¸ÏòÁíÒ»ÕÅÀàÐͱíµÄÒ»¸öIDÖµ)
ÎÒÏëµ½ÁËÁ½ÖÖ·½Ê½£»

»·¾³£ºPHP+MYSQL

1¡¢PHP ÏÈÖ´ÐÐÒ»Ìõ²éѯµÃµ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ