Sql Server 2000ÖØÖñêʶÁÐ
ÔÚSQL ServerÖÐ, ÎÒÃÇÓÐʱÐèÒªÔÚÇå¿ÕÊý¾Ý±íÖ®ºó£¬ÖØÐÂÌí¼Ó¼Ç¼ʱ£¬±êʶÁÐÖØÐ´Ó1¿ªÊ¼¼ÆÊý¡£
ÎÒÃÇÖ»ÐèÒªÔÚ²åÈë¼Ç¼֮ǰ£¬Ö´ÐÐÏÂÃæµÄÃüÁ
DBCC CHECKIDENT (±íÃû, RESEED, 0)
Èç¹ûÊÇÇå¿Õ±íÖÐÄÚÈÝÔÙÖØÖñêʶÁпÉÒÔÑ¡ÔñʹÓà Truncate Table ÃüÁ
Truncate Table tablename
TRUNCATE TABLE ÔÚ¹¦ÄÜÉÏÓë²»´ø WHERE ×Ó¾äµÄ DELETE Óï¾äÏàͬ
TRUNCATE TABLE ɾ³ý±íÖеÄËùÓÐÐУ¬µ«±í½á¹¹¼°ÆäÁС¢Ô¼Êø¡¢Ë÷ÒýµÈ±£³Ö²»±ä¡£ÐÂÐбêʶËùÓõļÆÊýÖµÖØÖÃΪ¸ÃÁеÄÖÖ×Ó¡£
Ïà¹ØÎĵµ£º
Çå¿ÕÈÕÖ¾
1£®´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî
DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
2.ÔÙ´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãҪѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,Ö±½ÓÊäÈëÕâ¸öÊý,È·¶¨¾Í¿ÉÒÔÁË¡£
......
¶ÔÓÚ½ñÌìµÄ RDBMS Ìåϵ½á¹¹¶øÑÔ£¬ËÀËøÄÑÒÔ±ÜÃâ — ÔÚ¸ßÈÝÁ¿µÄ OLTP »·¾³ÖиüÊǼ«ÎªÆÕ±é¡£ÕýÊÇÓÉÓÚ .NET µÄ¹«¹²ÓïÑÔÔËÐпâ (CLR) µÄ³öÏÖ£¬ SQL Server 2005 ²ÅµÃÒÔΪ¿ª·¢ÈËÔ±ÌṩһÖÖеĴíÎó´¦Àí·½·¨¡£ÔÚ±¾ÔÂרÀ¸ÖУ¬ Ron Talmage ΪÄú½éÉÜÈçºÎʹÓà TRY/CATCH Óï¾äÀ´½â¾öÒ»¸öËÀËøÎÊÌâ¡£
Ò»¸öʾÀýËÀËø
ÈÃÎÒÃÇ´ÓÕâÑùÒ ......
¡¡ ¡ù Êý¾Ý¶¨ÒåÓïÑÔ(DDL)£¬ÀýÈ磺CREATE¡¢DROP¡¢ALTERµÈÓï¾ä¡£
¡¡¡¡¡ù Êý¾Ý²Ù×÷ÓïÑÔ(DML)£¬ÀýÈ磺INSERT£¨²åÈ룩¡¢UPDATE£¨Ð޸ģ©¡¢DELETE£¨É¾³ý£©Óï¾ä¡£
¡¡¡¡¡ù Êý¾Ý²éѯÓïÑÔ(DQL)£¬ÀýÈ磺SELECTÓï¾ä¡£
¡¡¡¡¡ù Êý¾Ý¿ØÖÆÓïÑÔ(DCL)£¬ÀýÈ磺GRANT¡¢REVOKE¡¢COMMIT¡¢ROLLBACKµÈÓï¾ä¡£
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
C ......
ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ
Ô¤±¸ÖªÊ¶
1£®OLE×Ô¶¯»¯º¯Êý
OLE×Ô¶¯»¯Ê¹Ó¦ÓóÌÐòÄܹ»¶ÔÁíÒ»¸öÓ¦ÓóÌÐòÖÐʵÏֵĶÔÏó½øÐвÙ×÷£¬»òÕß½«¶ÔÏ󹫿ªÒÔ±ã¿ÉÒÔ¶ÔÆä½øÐвÙ×÷¡£×Ô¶¯»¯¿Í»§¶ËÊǿɶÔÊôÓÚÁíÒ»¸öÓ¦ÓóÌÐòµÄ¹«¿ª¶ÔÏó½øÐвÙ×÷µÄÓ¦ÓóÌÐò£¬±¾ÎÄÖµµÃÊÇSql Server¡£¹«¿ ......
--²âÊÔ±í
create table tb_month
(monthid varchar(2),mongthName varchar(50))
insert into tb_month
select '01','Ò»ÔÂ'
union all select '02','¶þÔÂ'
union all select '03','ÈýÔÂ'
union all select '04','ËÄÔÂ'
union all select '05','ÎåÔÂ'
union all select '06','ÁùÔÂ'
union all select '07','ÆßÔÂ'
......