数据库技术SQL Server
Oceanson
这个作者很懒,什么都没留下…
展开
-
SQL select 语句的简单执行顺序
深刻理解select的执行顺序是数据分析的基础1. from 子句组装来自不同数据源的数据2. where 子句基于制定的条件对纪录进行筛选。3. group by 子句将数据划分为多个组。4. 使用聚合函数进行计算。5. 使用having子句筛选分组。6. 计算所有的表达式7. 使用order by 对结果进行排序转载 2007-06-27 10:40:00 · 1165 阅读 · 0 评论 -
Understanding Object Ownership in sql 2000(how to change the schema table name in sql 2000)
Introduction Object ownership is often confusing for new DBAs and developers. You would think that tables, views, and stored procedures created by a member of the db_owner database role would be own转载 2007-07-23 14:54:00 · 1284 阅读 · 0 评论