Question

asp如何删除数据库某表中的所有记录？

比如，要删除表aspxweb里的所有记录，让它变成一个空表。请问代码怎么写？

Answer 1

<%
Dim conn,connSql
ConnSql="driver={SQL Server};server=.; uid=sa;pwd=sa;database=lab1"
Set conn = Server.CreateObject("Adodb.Connection")
conn.open connSql
dim dsql
dsql="delete from [table]"
conn.execute dsql
conn.execute dsql
conn.close
set conn=nothing
%>

Answer 2

<%
Dim
conn,connSql
ConnSql="driver={SQL
Server};server=.;
uid=sa;pwd=sa;database=lab1"
Set
conn
=
Server.CreateObject("Adodb.Connection")
conn.open
connSql
dim
dsql
dsql="delete
from
[table]"
conn.execute
dsql
conn.execute
dsql
conn.close
set
conn=nothing
%>

Answer 3

delete from [table]

Answer 4

TRUNCATE TABLE aspxweb

速度比用DELETE快