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

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

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

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


Ïà¹ØÎÊ´ð£º

°ÑÒ»¸ösqlserverÌáÈ¡µÄdataset²åÈëµ½sqlce

Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ

C# code:
private void connserver()
{

Cursor.Current = Cursors.WaitCursor;
try
{
......

ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¶¼¼ÓÉÏͬһ¸öÖµ£¿

ÈçºÎ½«sqlserver ±íµÄÒ»¸ö×ֶεÄÖµ¼ÓÉÏͬһ¸öÖµ£¿

ÊÇÉí·ÝÖ¤µ¼³öexcel±ä¿ÆÑ§¼ÆÊý·¨£¬Ï뽫ÕâÒ»×ֶεÄÖµÖ±½Ó¼ÓÉÏÒ»¸ö ¡¯

ÇëÎÊÈçºÎд£¿
SQL code:
update ry set Éí·ÝÖ¤ºÅ=Éí·ÝÖ¤ºÅ+'*'

UPdateÒ»Ï ......

Çë½Ì£ºÈçºÎ½«sqlserverºÍoracleÖеÄÊý¾ÝÏ໥¸´ÖÆ

ÄÜ·ñÓÃÓï¾äʵÏÖ¡£¶ø²»ÊÇÏֳɵŤ¾ß£¿

Â¥ÉϵÄÐֵܿÉÒÔÏêϸһЩÂð£¿
×£Äã½ÚÈÕ¿ìÀÖ£¡¹þ¹þ

½ÚÈÕ¿ìÀÖ

SQL code:

Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
......

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

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

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

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

¼±ÇóÖúSqlserver´æ´í¹ý³Ì

CREATE PROCEDURE [dbo].[getNews]
@News_subject nvarchar(1000) =null,
@News_content nvarchar(max) =null,
@type int,
@FileName varchar(255) =null,
@descriptions nvarchar(1000) =null,
@ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ