1. 

   老林 New Member

   Joined:

   Sep 6, 2005

   Messages:

   10,580

   Likes Received:

   36

   在用mssql时　偶尔需要清空数据　以前一直用delete　有个缺陷：自动编号的ID列不能归零。
   
   今天发现有个好的办法：
   
   

   Code:

   Truncate Table [表名]

   这个可以直接清空数据（delete是逐行删除），并把自动编号的归零。
   
   over~
   

    

   #1 老林, Mar 15, 2006
2. 

   亚马逊的雨季 New Member

   Joined:

   Sep 5, 2005

   Messages:

   1,984

   Likes Received:

   12

   Access 中好用不？

    

   #2 亚马逊的雨季, Mar 15, 2006
3. 

   老林 New Member

   Joined:

   Sep 6, 2005

   Messages:

   10,580

   Likes Received:

   36

   Access 中没试过
   
   Access 可以直接压缩一下数据库也可以将自动编号归零

    

   #3 老林, Mar 15, 2006

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in