随笔 - 52
文章 - 0
评论 - 31
阅读 -
18万
12 2013 档案
怎么解决安装SqlServer2008总是提示Restart computer as failed
摘要：安装SqlServer2008总是提示Restart computer as failed，重启电脑依然报这个錯。解决办法是在cmd窗口中使用命令setup.exe /SkipRules=RebootRequiredCheck /ACTION=install进行安装，如果是卸载就把参数ACTION的值换成uninstall。在win8上面安装SqlServer2008 Express不成功的解决办法是安装SQL Server® 2008 R2 SP1 - Express Edition。下载地址：https://www.microsoft.com/en-us/download/det
阅读全文
分页查询的SQL语句
摘要：每页10个记录，查询出第2页的记录如果不带查询条件：select top 10 * from WorkRecord where (Id not IN (select top (10 * 2) Id FROM WorkRecord))如果带查询条件select top 10 * from (select * FROM WorkRecord where (CatchTime > '2013/11/18 0:00:00' and CatchTime '2013/11/18 0:00:00' and CatchTime < '2013/12/18 2
阅读全文
