Sql Server 2000ÖØÖñêʶÁÐ
ÔÚSQL ServerÖÐ, ÎÒÃÇÓÐʱÐèÒªÔÚÇå¿ÕÊý¾Ý±íÖ®ºó£¬ÖØÐÂÌí¼Ó¼Ç¼ʱ£¬±êʶÁÐÖØÐ´Ó1¿ªÊ¼¼ÆÊý¡£
ÎÒÃÇÖ»ÐèÒªÔÚ²åÈë¼Ç¼֮ǰ£¬Ö´ÐÐÏÂÃæµÄÃüÁ
DBCC CHECKIDENT (±íÃû, RESEED, 0)
Èç¹ûÊÇÇå¿Õ±íÖÐÄÚÈÝÔÙÖØÖñêʶÁпÉÒÔÑ¡ÔñʹÓà Truncate Table ÃüÁ
Truncate Table tablename
TRUNCATE TABLE ÔÚ¹¦ÄÜÉÏÓë²»´ø WHERE ×Ó¾äµÄ DELETE Óï¾äÏàͬ
TRUNCATE TABLE ɾ³ý±íÖеÄËùÓÐÐУ¬µ«±í½á¹¹¼°ÆäÁС¢Ô¼Êø¡¢Ë÷ÒýµÈ±£³Ö²»±ä¡£ÐÂÐбêʶËùÓõļÆÊýÖµÖØÖÃΪ¸ÃÁеÄÖÖ×Ó¡£
Ïà¹ØÎĵµ£º
µÚÒ»ÖÖ·½·¨:
string str="server=.;uid=sa;pwd=111111;database=text_db";//Á¬½Ó×Ö·û´®
SqlConnection SCON = null;//Á¬½Ó¶ÔÏó
&n ......
¡¡ ¡ù Êý¾Ý¶¨ÒåÓïÑÔ(DDL)£¬ÀýÈ磺CREATE¡¢DROP¡¢ALTERµÈÓï¾ä¡£
¡¡¡¡¡ù Êý¾Ý²Ù×÷ÓïÑÔ(DML)£¬ÀýÈ磺INSERT£¨²åÈ룩¡¢UPDATE£¨Ð޸ģ©¡¢DELETE£¨É¾³ý£©Óï¾ä¡£
¡¡¡¡¡ù Êý¾Ý²éѯÓïÑÔ(DQL)£¬ÀýÈ磺SELECTÓï¾ä¡£
¡¡¡¡¡ù Êý¾Ý¿ØÖÆÓïÑÔ(DCL)£¬ÀýÈ磺GRANT¡¢REVOKE¡¢COMMIT¡¢ROLLBACKµÈÓï¾ä¡£
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
C ......
SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á(2)
3¡¢ ½¨Á¢¾µÏñ
ÓÉÓÚÊÇʵÑ飬ûÓÐΪ·þÎñÆ÷ÅäÖÃË«Íø¿¨£¬IPµØÖ·ÓëͼÓе㲻һÑù£¬µ«ÊÇÔÀíÒ»Ñù¡£
--Ö÷»úÖ´ÐУº
1ALTER DATABASE shishan SET PARTNER = 'TCP://10.168.6.45:5022';
--Èç¹ûÖ÷ÌåÖ´Ðв»³É¹¦£¬³¢ÊÔÔÚ±¸»úÖÐÖ´ÐÐÈçÏÂÓï¾ä£º
1ALTER DATABASE ......
ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ
Ô¤±¸ÖªÊ¶
1£®OLE×Ô¶¯»¯º¯Êý
OLE×Ô¶¯»¯Ê¹Ó¦ÓóÌÐòÄܹ»¶ÔÁíÒ»¸öÓ¦ÓóÌÐòÖÐʵÏֵĶÔÏó½øÐвÙ×÷£¬»òÕß½«¶ÔÏ󹫿ªÒÔ±ã¿ÉÒÔ¶ÔÆä½øÐвÙ×÷¡£×Ô¶¯»¯¿Í»§¶ËÊǿɶÔÊôÓÚÁíÒ»¸öÓ¦ÓóÌÐòµÄ¹«¿ª¶ÔÏó½øÐвÙ×÷µÄÓ¦ÓóÌÐò£¬±¾ÎÄÖµµÃÊÇSql Server¡£¹«¿ ......