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

SqlServer µÄ´íÎó

  ÎÒµÄÊý¾Ý¿âͻȻ±¨Ò»¸öºÜÓôÃÆµÄ´íÎ󣬵¼ÖÂÊý¾ÝÎÞ·¨²é¿´£¬
    ´íÎóÌáʾΪ£º
                  ÔÚÎļþ 'G:\data\ÆóÒµ¹ÜÀíÊý¾Ý¿â1_data.ndf' ÖС¢Æ«ÒÆÁ¿Îª 0x00000000020000 µÄλÖÃÖ´ÐÐ ¶ÁÈ¡ ÆÚ¼ä£¬²Ù×÷ϵͳÒѾ­Ïò SQL Server ·µ»ØÁË´íÎó 21(É豸δ¾ÍÐ÷¡£)¡£SQL Server ´íÎóÈÕÖ¾ºÍϵͳʼþÈÕÖ¾ÖÐµÄÆäËûÏûÏ¢¿ÉÄÜÌṩÁ˸üÏêϸÐÅÏ¢¡£ÕâÊÇÒ»¸öÍþвÊý¾Ý¿âÍêÕûÐÔµÄÑÏÖØÏµÍ³¼¶´íÎóÌõ¼þ£¬±ØÐëÁ¢¼´¾ÀÕý¡£ÇëÖ´ÐÐÍêÕûµÄÊý¾Ý¿âÒ»ÖÂÐÔ¼ì²é(DBCC CHECKDB)¡£´Ë´íÎó¿ÉÒÔÓÉÐí¶àÒòËØµ¼Ö£»ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ SQL Server Áª»ú´ÔÊé¡£

          Íû¸÷λÃ÷ʾ  СµÜÔÚ´ËÏÈлл¸÷λÀ²£¡



×öһϴÅÅÌɨÃè scandisk È»ºócheckdbÒ»ÏÂ

DBCC¼ì²éһϣ¡

DBCC CHECKDB ¿´¿´´íÎóËùÔÚ
ÓпÉÄÜÊÇË÷ÒýµÄÎÊÌâ

  ¸Ðл¸÷λµÄ¹Ø×¢£¬¸÷λÌáµ½µÄÎÒ¶¼ÊÔ¹ýÁË£¬µ«»¹ÊÇûÓÐÓ𡣬ÊDz»Êdz£¹æµÄµ÷ÖÆÊDz»Êǽâ¾ö²»ÁË£¿

    ûÈËÓöµ½¹ý´ËÎÊÌâÂð£¬Èç¹û½â¾öÁ˼ӷ֣¡

ÊÇÄãÊý¾Ý¿â³öÎÊÌâÁË Óб¸·Ýû ÓеĻ°ÖØÐ»¹Ô­Ï¾ͺÃÁË

ËäȻûÓÐÕýÈ·´ð°¸£¬µ«ÊÇ»¹ÊÇлл´ó¼ÒÀ²


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

sqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°

±ÈÈç Óû§Ãû£¬ÎÒ³ÌÐòµÄÒªÇóÊÇ10λ×Ö·ûÒÔÄÚ£¬ËùÒÔ£º
Èç¹ûÎÒsqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°£¬

1.»á²»»á¼õÉÙÊý¾Ý¿Õ¼ä£¿
2.»á²»»áÌá¸ßÎÒ³ÌÐòµÄЧÂÊ£¿
3.ÓÐûÓбØÒª£¿

СµÜÏÈл ......

SqlServer´æ´¢½á¹¹ÓëÒ»¸öË÷ÒýÎÊÌâ

SQL code:

CREATE TABLE TUser
(
FName CHAR(8000),
FAge INT,
FSex bit
)
INSERT INTO TUser
SELECT 'ÕÅÈý',18,1
UNION ALL
SELECT 'ÀîËÄ',20,1
UNION ALL
SELECT 'ÍõÎå',32,1
UNION ALL
SE ......

sqlserver µÄÊý¾Ý»¹Ô­

»¹Ô­µÄ±¨´íÐÅÏ¢:

System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)

Çë¸÷λ¸ßÊÖ°ïæ½â¾ö

»¹Ô­µÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......

sqlserver count,order by ²éѯÂý

±íÖÐÊý¾Ý 700ÍòÌõ×óÓÒ£¬29¸ö×ֶΣ¬×Ô¶¯Ôö³¤ÁÐÉèΪÖ÷¼ü£¬ ʹÓÃcount£¨1£© ²éѯ×ÜÌõÊýÐèÒª1·ÖÖÓ£¬
select top 1000 ×Ö¶ÎÃû  from ±í order by ʱ¼ä(¸Ã×Ö¶ÎÓÐÖØ¸´ÖµºÍnullÖµ)  ÕâÑùµÄÓï¾ä²éѯ¸üÊÇÂýµÃ»ù± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ