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

Sql Server 2000ÖØÖñêʶÁÐ

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


Ïà¹ØÎĵµ£º

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

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

SQL²éѯÓï¾ä¾«»ª

¡¡   ¡ù Êý¾Ý¶¨ÒåÓïÑÔ(DDL)£¬ÀýÈ磺CREATE¡¢DROP¡¢ALTERµÈÓï¾ä¡£
¡¡¡¡¡ù Êý¾Ý²Ù×÷ÓïÑÔ(DML)£¬ÀýÈ磺INSERT£¨²åÈ룩¡¢UPDATE£¨Ð޸ģ©¡¢DELETE£¨É¾³ý£©Óï¾ä¡£
¡¡¡¡¡ù Êý¾Ý²éѯÓïÑÔ(DQL)£¬ÀýÈ磺SELECTÓï¾ä¡£
¡¡¡¡¡ù Êý¾Ý¿ØÖÆÓïÑÔ(DCL)£¬ÀýÈ磺GRANT¡¢REVOKE¡¢COMMIT¡¢ROLLBACKµÈÓï¾ä¡£
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
C ......

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

SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á(2)
3¡¢ ½¨Á¢¾µÏñ
ÓÉÓÚÊÇʵÑ飬ûÓÐΪ·þÎñÆ÷ÅäÖÃË«Íø¿¨£¬IPµØÖ·ÓëͼÓе㲻һÑù£¬µ«ÊÇÔ­ÀíÒ»Ñù¡£
--Ö÷»úÖ´ÐУº
1ALTER DATABASE shishan SET PARTNER = 'TCP://10.168.6.45:5022';
--Èç¹ûÖ÷ÌåÖ´Ðв»³É¹¦£¬³¢ÊÔÔÚ±¸»úÖÐÖ´ÐÐÈçÏÂÓï¾ä£º
1ALTER DATABASE ......

ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ


 ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ
Ô¤±¸ÖªÊ¶
    1£®OLE×Ô¶¯»¯º¯Êý
    OLE×Ô¶¯»¯Ê¹Ó¦ÓóÌÐòÄܹ»¶ÔÁíÒ»¸öÓ¦ÓóÌÐòÖÐʵÏֵĶÔÏó½øÐвÙ×÷£¬»òÕß½«¶ÔÏ󹫿ªÒÔ±ã¿ÉÒÔ¶ÔÆä½øÐвÙ×÷¡£×Ô¶¯»¯¿Í»§¶ËÊǿɶÔÊôÓÚÁíÒ»¸öÓ¦ÓóÌÐòµÄ¹«¿ª¶ÔÏó½øÐвÙ×÷µÄÓ¦ÓóÌÐò£¬±¾ÎÄÖµµÃÊÇSql Server¡£¹«¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ