'用ado怎样实现 '工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号) '---------------------------------------------------------------------------- Private Sub Form_Load() Dim adoCN As New ADODB.Connection '定义数据库的连接 '连接Access数据库 adoCN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.MDB;Persist Security Info=False" '连接Sqlserver数据库 adoCN.Open "Provider=SQLOLEDB;Data Source=servername;User Id=sa;PassWord=****;Initial Catalog=test" '删除所有记录 adoCN.Execute "Delete From Table1" '删除 id 从 10-100 的所有记录 adoCN.Execute "Delete From Table1 Where ID>1 And ID<100"
delete from 表 如何删除 id 从 10-100 的所有记录
delete form 表 where id>=10 and id<=100
delete from 表名 where id>=10 and id<=100
DELETE [FROM] 表名
或者
TRUNCATE 表名
是全删除
第二问前几位都说了
'工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号)
'----------------------------------------------------------------------------
Private Sub Form_Load()
Dim adoCN As New ADODB.Connection '定义数据库的连接
'连接Access数据库
adoCN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.MDB;Persist Security Info=False"
'连接Sqlserver数据库
adoCN.Open "Provider=SQLOLEDB;Data Source=servername;User Id=sa;PassWord=****;Initial Catalog=test"
'删除所有记录
adoCN.Execute "Delete From Table1"
'删除 id 从 10-100 的所有记录
adoCN.Execute "Delete From Table1 Where ID>1 And ID<100"