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

sql serverÆô¶¯²»ÁË£¡£¡£¡¼±¡­¡­

  ÔÚÅäÖ÷þÎñÆ÷Àï´ò¿ªmssqlserverʱÌáʾ´íÎó£¬Çë²é¿´Ê¼þÈÕÖ¾ºÍʲô´íÎ󱨸æÖ®ÀàµÄ¡£µ«ÊÇSQLEXPRESS¿ÉÒÔÆô¶¯¡£
  ÇëÎÊÒ»ÏÂÒ»¸öʼþÈÕÖ¾ÔÚÄÄÀï²é¿´£¬»¹ÓÐÕâÊÇÔõô»ØÊ£¬Ôõô½â¾ö°¡£¿
SQL Server ·þÎñ¿ÉÄÜÎÞ·¨Æô¶¯²¢ÔÚ SQL Server ´íÎóÈÕÖ¾ÖÐÄú¿ÉÄÜ»áÊÕµ½ÒÔÏ´íÎóÐÅÏ¢»òÔÚʼþ²é¿´Æ÷Ó¦ÓóÌÐòµÇ¼¼ÆËã»úµÄ£º
spid5 ½»»» tempdb Êý¾Ý¿â¡£
spid5 ¼ì²éÎļþ 'DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF' µÄÉÈÇø´óСʱ Encountered ÒâÍâµÄ´íÎó¡£ ¼ì²é SQL Server ´íÎóÈÕÖ¾ÏêϸÐÅÏ¢¡£
spid5 CREATE DATABASE ʧ°Ü¡£ ²»ÄÜ´´½¨ÁгöµÄijЩÎļþÃû³Æ¡£ Çë¼ì²éÒÔǰµÄ´íÎó¡£
spid5 ´íÎó£º 823£¬ÑÏÖØ³Ì¶È£º 24£¬×´Ì¬£º 6
spid5 ¹ý³ÌÖмì²âµ½ I / O ´íÎó 38(Reached the end of the file.) ¶ÁÈ¡Æ«ÒÆÁ¿Îļþ DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF ÖÐµÄ 0000000000000000¡£
spid5 ¾¯¸æ£º ¼¤»îËùÓÐ tempdb ÎļþÎÊÌâ¡£ Çë²ÎÔÄÒÔǰµÄ´íÎó¡£ ÖØÐÂÆô¶¯·þÎñÆ÷ÓÃ-f À´¸üÕýÕâÖÖÇé¿ö¡£


ÒýÓÃ
SQL Server ·þÎñ¿ÉÄÜÎÞ·¨Æô¶¯²¢ÔÚ SQL Server ´íÎóÈÕÖ¾ÖÐÄú¿ÉÄÜ»áÊÕµ½ÒÔÏ´íÎóÐÅÏ¢»òÔÚʼþ²é¿´Æ÷Ó¦ÓóÌÐòµÇ¼¼ÆËã»úµÄ£º
spid5 ½»»» tempdb Êý¾Ý¿â¡£
spid5 ¼ì²éÎļþ 'DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF' µÄÉÈÇø´óСʱ Encountered ÒâÍâµÄ´íÎó¡£ ¼ì²é SQL Server ´íÎóÈÕÖ¾ÏêϸÐÅÏ¢¡£
spid5 CREATE DATABASE ʧ°Ü¡£ ²»ÄÜ´´½¨ÁгöµÄijЩÎļþÃû³Æ¡£ Çë¼ì²éÒÔǰµÄ´íÎó¡£
spid5 ´íÎó£º 823£¬ÑÏÖØ³Ì¶È£º 24£¬×´Ì¬£º 6
spid5 ¹ý³ÌÖмì²âµ½ I / O ´íÎó 38(Reached the end of the file.) ¶ÁÈ¡Æ«ÒÆÁ¿Îļþ DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF ÖÐµÄ 0000000000000000¡£
spid5 ¾¯¸æ£º ¼¤»îËù


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

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

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

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

½«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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ