随笔分类 -  SQL Server

未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序搜索
摘要：解决办法：去http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe下载。然后安装就行了。 阅读全文
posted @ 2015-12-03 10:03 vstarks 阅读(182) 评论(0) 推荐(0)
DISTINCT删除重复数据
摘要：DISTINCT 语法1 SELECT DISTINCT NAME FROM TABLENAME删除去重SQL语法DELETE FROM QuestionLib where ID in ( select min(ID) ID FROM QuestionLib group by NAME having... 阅读全文
posted @ 2015-11-17 10:36 vstarks 阅读(298) 评论(0) 推荐(0)