SQLServer
共 4 篇文章
SqlServer 查询sql执行时间
在查询分析器中输入以下内容: set statistics profile on set statistics io on set statistics time on go <这里写上你的语句...> go set statistics profile off set statistics io off set statistics time off 在2个go之间输入sql语句.然后在消息模式下查看.
2008-04-25 16:40 · SQLServer
SQL之Top 分页法
SQLServer: select * from ( select top @pageSize * from ( select top (@pageSize*@currentPage) * from page order by _id asc )t1 order by _id desc )t2 order by _id asc
2007-12-04 16:03 · SQLServer
SQLServer中区分大小写
在SqlServer中区分参数大小写的做法。 eg: select * from users where loginId=#loginId# collate Chinese_PRC_CS_AS_WS.
2007-11-28 20:46 · SQLServer