Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
假设要删除表A第一列的重复记录,代码:
Dim cmd As New SQLCommand
cmd.CommandText = "Delete From {表A} where [_Identify] Not In (Select max([_Identify]) From {表A} Group by 第一列)"
cmd.ExecuteNonQuery()
DataTables ("表A").Load()
列属性也可以设置