SqlServer µÄ´íÎó
ÎÒµÄÊý¾Ý¿âͻȻ±¨Ò»¸öºÜÓôÃÆµÄ´íÎ󣬵¼ÖÂÊý¾ÝÎÞ·¨²é¿´£¬
´íÎóÌáʾΪ£º
ÔÚÎļþ 'G:\data\ÆóÒµ¹ÜÀíÊý¾Ý¿â1_data.ndf' ÖС¢Æ«ÒÆÁ¿Îª 0x00000000020000 µÄλÖÃÖ´ÐÐ ¶ÁÈ¡ ÆÚ¼ä£¬²Ù×÷ϵͳÒѾÏò SQL Server ·µ»ØÁË´íÎó 21(É豸δ¾ÍÐ÷¡£)¡£SQL Server ´íÎóÈÕÖ¾ºÍϵͳʼþÈÕÖ¾ÖÐµÄÆäËûÏûÏ¢¿ÉÄÜÌṩÁ˸üÏêϸÐÅÏ¢¡£ÕâÊÇÒ»¸öÍþвÊý¾Ý¿âÍêÕûÐÔµÄÑÏÖØÏµÍ³¼¶´íÎóÌõ¼þ£¬±ØÐëÁ¢¼´¾ÀÕý¡£ÇëÖ´ÐÐÍêÕûµÄÊý¾Ý¿âÒ»ÖÂÐÔ¼ì²é(DBCC CHECKDB)¡£´Ë´íÎó¿ÉÒÔÓÉÐí¶àÒòËØµ¼Ö£»ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ SQL Server Áª»ú´ÔÊé¡£
Íû¸÷λÃ÷ʾ СµÜÔÚ´ËÏÈлл¸÷λÀ²£¡
×öһϴÅÅÌɨÃè scandisk È»ºócheckdbÒ»ÏÂ
DBCC¼ì²éһϣ¡
DBCC CHECKDB ¿´¿´´íÎóËùÔÚ
ÓпÉÄÜÊÇË÷ÒýµÄÎÊÌâ
¸Ðл¸÷λµÄ¹Ø×¢£¬¸÷λÌáµ½µÄÎÒ¶¼ÊÔ¹ýÁË£¬µ«»¹ÊÇûÓÐÓ𡣬ÊDz»Êdz£¹æµÄµ÷ÖÆÊDz»Êǽâ¾ö²»ÁË£¿
ûÈËÓöµ½¹ý´ËÎÊÌâÂð£¬Èç¹û½â¾öÁ˼ӷ֣¡
ÊÇÄãÊý¾Ý¿â³öÎÊÌâÁË Óб¸·Ýû ÓеĻ°ÖØÐ»¹ÔϾͺÃÁË
ËäȻûÓÐÕýÈ·´ð°¸£¬µ«ÊÇ»¹ÊÇлл´ó¼ÒÀ²
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
±ÈÈç Óû§Ãû£¬ÎÒ³ÌÐòµÄÒªÇóÊÇ10λ×Ö·ûÒÔÄÚ£¬ËùÒÔ£º
Èç¹ûÎÒsqlserver´Óvarchar(50)´æ´¢¸ÄΪÓÃvarchar(10)µÄ»°£¬
1.»á²»»á¼õÉÙÊý¾Ý¿Õ¼ä£¿
2.»á²»»áÌá¸ßÎÒ³ÌÐòµÄЧÂÊ£¿
3.ÓÐûÓбØÒª£¿
СµÜÏÈл ......
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 ......
»¹ÔµÄ±¨´íÐÅÏ¢:
System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)
Çë¸÷λ¸ßÊÖ°ïæ½â¾ö
»¹ÔµÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......
±íÖÐÊý¾Ý 700ÍòÌõ×óÓÒ£¬29¸ö×ֶΣ¬×Ô¶¯Ôö³¤ÁÐÉèΪÖ÷¼ü£¬ ʹÓÃcount£¨1£© ²éѯ×ÜÌõÊýÐèÒª1·ÖÖÓ£¬
select top 1000 ×Ö¶ÎÃû from ±í order by ʱ¼ä(¸Ã×Ö¶ÎÓÐÖØ¸´ÖµºÍnullÖµ) ÕâÑùµÄÓï¾ä²éѯ¸üÊÇÂýµÃ»ù± ......