![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
文章平均质量分 58
dnvodcwan
这个作者很懒,什么都没留下…
展开
-
SQL TOP N 分组统计
--分组统计select a.emp_id,b.emp_name,a.dept_no,a.bb_no,a.xh,a.idno,a.emp_no,a.beg_date,a.over_date,a.basesal from HRSys.dbo.EmpbaseSal a left join HRSys.dbo.Employee b on a.emp_id=b.emp_idwhere bases原创 2007-03-28 15:43:00 · 1059 阅读 · 0 评论 -
Inner Join 与 Exists 性能对比
经验显示,Inner Join 更快.select a.* from a Inner Join b On a.Id=b.ID where b.name=@name select a.* from a where exists(select id from b where id=a.id and name=@name)原创 2009-11-24 17:45:00 · 1066 阅读 · 0 评论 -
存儲過程分頁
create procedure TurnPage(@ContainerNo varchar(16),@isFilter smallint,@PageSize int,@CurrPage int,@isCheck smallint, --- check valid result@ResultTotal int output,@ResultSub int output,@SortOrder va原创 2010-04-03 08:34:00 · 467 阅读 · 0 评论