随笔分类 -  Database

SqlServer 查询sql执行时间
摘要：在查询分析器中输入以下内容： set statistics profile on set statistics io on set statistics time on go <这里写上你的sql语句...> go set statistics profile off set statistics io off set statistics time off 阅读全文
posted @ 2009-09-24 16:46 流泉飞石 阅读(822) 评论(0) 推荐(0)
SQL语句
摘要：--利用子查询指定返回范围的查询USE AdventureWorksselect * from (SELECT PSC.Name Category,p.Name Product,p.ListPrice, ROW_NUMBER() OVER(ORDER BY PSC.Name,P.ListPrice DESC) AS RowNumFROM Production.Product pJOIN Produ... 阅读全文
posted @ 2009-08-03 09:40 流泉飞石 阅读(189) 评论(0) 推荐(0)
AdventureWorks 数据字典
只有注册用户登录后才能阅读该文。
posted @ 2008-12-07 22:51 流泉飞石 阅读(48) 评论(0) 推荐(0)