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 À´¸üÕýÕâÖÖÇé¿ö¡£
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´
°à¼¶±í ½Ìʦ±í
°à¼¶ID & ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......