Natural Joins - Still not in MS SQL Server
来源:互联网 发布:淘宝上买的q币可以退吗 编辑:程序博客网 时间:2024/04/30 05:35
One of the coolest join options in Oracle is the Natural Join. Provided that the tables' columns were named such that the column name indicated which columns in two or more tables should be used for a join, it reduced the effort in writing SQL queries.
Instead of writing a:
SELECT ContactName, CityName
FROM Contact
JOIN City ON Contact.CityId = City.CityId
you could simply write:
SELECT ContactName, CityName
FROM Contact
NATURAL JOIN City
Considering how Microsoft has been trying to make development easier for software programmers, this is one feature that they ought to think about.
Instead of writing a:
SELECT ContactName, CityName
FROM Contact
JOIN City ON Contact.CityId = City.CityId
you could simply write:
SELECT ContactName, CityName
FROM Contact
NATURAL JOIN City
Considering how Microsoft has been trying to make development easier for software programmers, this is one feature that they ought to think about.
- Natural Joins - Still not in MS SQL Server
- Inside SQL Server Joins
- SQL Interview Preparation (in the context of MS SQL Server)
- NFS:server not responing ,still trying
- nfs:server is not responding, still trying
- nfs:server is not responding, still trying
- nfs:server is not responding,still trying
- nfs:server is not responding, still trying
- nfs:server is not responding, still trying .
- nfs:server is not responding, still trying
- nfs:server is not responding,still tryin
- nfs:server ***** not responding, still trying
- nfs:server is not responding, still trying
- nfs server not responding still trying解决方案
- SQL Joins
- SQL Joins
- SQL joins
- SQL JOINS
- 昨天的生活
- NPTL, NGPT
- 软件开发者面试百问
- 获取当前系统ProgramFiles的目录(C# 源代码)
- 听王子健教授讲政治复习的总结
- Natural Joins - Still not in MS SQL Server
- 应届毕业生,绝对有你不知道的——档案,面试,合同法,薪水,为人处事等问题
- Hibernate使用自定义类型UserType映射Oracle的Date类型
- LOADIMAGE真是怪事一堆
- 获取当前系统桌面路径(C# 代码)
- C语言常用转义字符表
- 关于ext在IE下的“ Internet Explorer 無法開啓網際網路網站 ”的问题
- 学习资料电子书籍文件下载总览
- WindowsXP 操作系统安装后为什么不能上网?