ITeye博客

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 Server中的datetime

Sql Server中的datetime类型不包括"dd/MM/yyyy"这种格式.

2008-04-24 11:47 · 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