Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

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 ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ