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

Sql Server 2000ÖØÖñêʶÁÐ

ÔÚSQL ServerÖÐ, ÎÒÃÇÓÐʱÐèÒªÔÚÇå¿ÕÊý¾Ý±íÖ®ºó£¬ÖØÐÂÌí¼Ó¼Ç¼ʱ£¬±êʶÁÐÖØÐ´Ó1¿ªÊ¼¼ÆÊý¡£
ÎÒÃÇÖ»ÐèÒªÔÚ²åÈë¼Ç¼֮ǰ£¬Ö´ÐÐÏÂÃæµÄÃüÁ
DBCC CHECKIDENT (±íÃû, RESEED, 0)
Èç¹ûÊÇÇå¿Õ±íÖÐÄÚÈÝÔÙÖØÖñêʶÁпÉÒÔÑ¡ÔñʹÓà Truncate Table ÃüÁ
Truncate Table tablename
TRUNCATE TABLE ÔÚ¹¦ÄÜÉÏÓë²»´ø WHERE ×Ó¾äµÄ DELETE Óï¾äÏàͬ
TRUNCATE TABLE ɾ³ý±íÖеÄËùÓÐÐУ¬µ«±í½á¹¹¼°ÆäÁС¢Ô¼Êø¡¢Ë÷ÒýµÈ±£³Ö²»±ä¡£ÐÂÐбêʶËùÓõļÆÊýÖµÖØÖÃΪ¸ÃÁеÄÖÖ×Ó¡£


Ïà¹ØÎĵµ£º

SQL·ÖÒ³²éѯ

·ÖÒ³sql²éѯÔÚ±à³ÌµÄÓ¦Óúܶ࣬Ö÷ÒªÓд洢¹ý³Ì·ÖÒ³ºÍsql·ÖÒ³Á½ÖÖ£¬ÎұȽÏϲ»¶ÓÃsql·ÖÒ³£¬Ö÷ÒªÊǺܷ½±ã¡£ÎªÁËÌá¸ß²éѯЧÂÊ£¬Ó¦ÔÚÅÅÐò×Ö¶ÎÉϼÓË÷Òý¡£sql·ÖÒ³²éѯµÄÔ­ÀíºÜ¼òµ¥£¬±ÈÈçÄãÒª²é100ÌõÊý¾ÝÖеÄ30-40Ìõ£¬ÄãÏȲéѯ³öǰ40Ìõ£¬ÔÙ°ÑÕâ30Ìõµ¹Ðò£¬ÔÙ²é³öÕâµ¹ÐòºóµÄǰʮÌõ£¬×îºó°ÑÕâÊ®Ìõµ¹Ðò¾ÍÊÇÄãÏëÒªµÄ½á¹û¡£
   ......

Óû§saµÇ¼ʧ°Ü,¸ÃÓû§Óë¿ÉÐÅsql serverÁ¬½ÓÎÞ¹ØÁª

Õâ¸öÓпÉÄÜÊÇÄãÔÚ°²×°SQL SERVER2005µÄʱºòÑé֤ģʽûÓÐÉèÖúÃ.
1.Ñ¡ÖзþÎñÆ÷(ÓÒ¼ü)->ÊôÐÔ->°²È«ÐÔ->·þÎñÆ÷Éí·ÝÑéÖ¤ÐÞ¸ÄΪ"SQL SERVERºÍWINDOWSÉí·ÝÑé֤ģʽ"
2.Õ¹¿ª·þÎñÆ÷ÉϵÄ"°²È«ÐÔ"->µÇ½Ãû->Ñ¡ÖÐSAµÇ½ÕʺÅ(ÓÒ¼ü)->״̬->µÇ½ÐÞ¸ÄΪÆôÓÃ.
 
°²×°ÍêSQL Serverºó,¿ÉÒÔÓÃWindowsÉí·Ý ......

C#Ò»´ÎÁ¬½ÓÊý¾Ý¿âÖ´ÐжàÌõsqlÓï¾ä(ÈýÖÖ·½·¨)

µÚÒ»ÖÖ·½·¨:
            string str="server=.;uid=sa;pwd=111111;database=text_db";//Á¬½Ó×Ö·û´®
            SqlConnection SCON = null;//Á¬½Ó¶ÔÏó
       &n ......

ÈçºÎ½« Access Êý¾Ý¿âת»»µ½ SQL Server

http://support.microsoft.com/default.aspx/kb/237980/zh-cn
½« Access Êý¾Ý¿âת»»Îª SQL Server µÄ×î¼ò±ã·½·¨ÊÇʹÓÃÉýǨÏòµ¼¡£ÉýǨÏòµ¼£º
±£ÁôÊý¾Ý¿â½á¹¹£¬°üÀ¨Êý¾Ý¡¢Ë÷ÒýºÍĬÈÏÉèÖá£
×Ô¶¯½« Access ÓÐЧÐÔ¹æÔòºÍĬÈÏÉèÖÃת»»ÎªÊʵ±µÄ SQL Server µÈЧÄÚÈÝ¡£
ÔÚÉýǨºó±£³Ö±í¹ØÏµºÍ²ÎÕÕÍêÕûÐÔ¡£
ÒªÔÚ Access 2000 ......

SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á(1)

SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á
 
Ò»¡¢ ¾µÏñ¼ò½é
1¡¢ ¼ò½é
Êý¾Ý¿â¾µÏñÊǽ«Êý¾Ý¿âÊÂÎñ´¦Àí´ÓÒ»¸öSQL ServerÊý¾Ý¿âÒÆ¶¯µ½²»Í¬SQL Server»·¾³ÖеÄÁíÒ»¸öSQL ServerÊý¾Ý¿âÖС£¾µÏñ²»ÄÜÖ±½Ó·ÃÎÊ;ËüÖ»ÓÃÔÚ´íÎó»Ö¸´µÄÇé¿öϲſÉÒÔ±»·ÃÎÊ¡£
Òª½øÐÐÊý¾Ý¿â¾µÏñËùÐèµÄ×îСÐèÇó°üÀ¨ÁËÁ½¸ö²»Í¬µÄSQL ServerÔËÐл·¾³¡£Ö÷·þÎñÆ÷± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ