Learn about Microsoft SQL Server 2008 Insider: The Basics of T-SQL syntax-4th Chapter

4th Zhang Ziyi (query

4.2.1 Exist predicate:

 UseTSQLFundamentals2008Select *  fromSales.customers asCwhereC.country=N'Spain'Select *  fromSales.customers asCwhereC.country=N'Spain'  and exists(Select *  fromSales.orders asOwhereO.custid=C.custid)Select *  fromSales.customers asCwhereC.country=N'Spain'  and  not exists(Select *  fromSales.orders asOwhereO.custid=C.custid)

View Code

4.3.2 Continuous Gathering and

Select object_id('Sales.ordertotalsbyyear')if object_id('Sales.ordertotalsbyyear') is  not NULL  Drop ViewSales.ordertotalsbyyearGoCreate ViewSales.ordertotalsbyyear withschemabinding as   Select      Year(o.orderdate) asOrderYear,SUM(Od.qty) asQty fromsales.orders asoJoinSales.orderdetails asOd onO.orderid=Od.orderidGroup  by  Year(o.orderdate)Go

View Code

Learn about Microsoft SQL Server 2008 Insider: The Basics of T-SQL syntax-4th Chapter