SqlServer µÄ´íÎó
ÎÒµÄÊý¾Ý¿âͻȻ±¨Ò»¸öºÜÓôÃÆµÄ´íÎ󣬵¼ÖÂÊý¾ÝÎÞ·¨²é¿´£¬
´íÎóÌáʾΪ£º
ÔÚÎļþ 'G:\data\ÆóÒµ¹ÜÀíÊý¾Ý¿â1_data.ndf' ÖС¢Æ«ÒÆÁ¿Îª 0x00000000020000 µÄλÖÃÖ´ÐÐ ¶ÁÈ¡ ÆÚ¼ä£¬²Ù×÷ϵͳÒѾÏò SQL Server ·µ»ØÁË´íÎó 21(É豸δ¾ÍÐ÷¡£)¡£SQL Server ´íÎóÈÕÖ¾ºÍϵͳʼþÈÕÖ¾ÖÐµÄÆäËûÏûÏ¢¿ÉÄÜÌṩÁ˸üÏêϸÐÅÏ¢¡£ÕâÊÇÒ»¸öÍþвÊý¾Ý¿âÍêÕûÐÔµÄÑÏÖØÏµÍ³¼¶´íÎóÌõ¼þ£¬±ØÐëÁ¢¼´¾ÀÕý¡£ÇëÖ´ÐÐÍêÕûµÄÊý¾Ý¿âÒ»ÖÂÐÔ¼ì²é(DBCC CHECKDB)¡£´Ë´íÎó¿ÉÒÔÓÉÐí¶àÒòËØµ¼Ö£»ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ SQL Server Áª»ú´ÔÊé¡£
Íû¸÷λÃ÷ʾ СµÜÔÚ´ËÏÈлл¸÷λÀ²£¡
×öһϴÅÅÌɨÃè scandisk È»ºócheckdbÒ»ÏÂ
DBCC¼ì²éһϣ¡
DBCC CHECKDB ¿´¿´´íÎóËùÔÚ
ÓпÉÄÜÊÇË÷ÒýµÄÎÊÌâ
¸Ðл¸÷λµÄ¹Ø×¢£¬¸÷λÌáµ½µÄÎÒ¶¼ÊÔ¹ýÁË£¬µ«»¹ÊÇûÓÐÓ𡣬ÊDz»Êdz£¹æµÄµ÷ÖÆÊDz»Êǽâ¾ö²»ÁË£¿
ûÈËÓöµ½¹ý´ËÎÊÌâÂð£¬Èç¹û½â¾öÁ˼ӷ֣¡
ÊÇÄãÊý¾Ý¿â³öÎÊÌâÁË Óб¸·Ýû ÓеĻ°ÖØÐ»¹ÔϾͺÃÁË
ËäȻûÓÐÕýÈ·´ð°¸£¬µ«ÊÇ»¹ÊÇлл´ó¼ÒÀ²
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
´úÂ룺
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ» ......
ÏÖÒ»·þÎñÆ÷£¬Ö§³ÖRAID5/RAID1+0µÈ£¬ÓÐ4¿éÒ»ÑùÐͺŵÄÓ²ÅÌ£¬°²×°ÁËRAID¿¨¡£
ÎÒËÑË÷ÁËÂÛ̳£¬ÓÐ˵Ҫ°ÑÊý¾Ý¿âÎļþ·Ö²¼ÔÚ²»Í¬´ÅÅÌ£¬µ«ÊÇ£¬×öraid5»òraid10ºó£¬4¿éÓ²Å̺ÃÏñ³ÉΪһÌåÁË£¬ÎÒ·Ö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 ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......