Except Operator

In this video, Marco show how to use EXCEPT and ilustrates the difference between INTERSECT and EXCEPT. When you first look at these two operators you'll see that you could do what they do with joins, but for the sitations where they fit, they are a lot more elegant and more clearly express the intent. Worth using!

From Portugal. 26 years old. Experience in a wide variety of business intelligence projects and industries (in particular communications, automotive, billing & payments, CRM). Currently working at the biggest Portuguese communications company as BI Architect, Performance/Tuning and Project Manadgement.

Marco Francisco on 7/2/2010

Take a deep look into http://www.bidn.com/blogs/marcoadf/bidn-blog/734/intersect-and-except-operators

B on 7/2/2010

same problem with all his videos - hard to understand his accent

maryann stickney on 7/2/2010

what version of sql server is this video for

rpanigas@hoopp.com on 7/2/2010

Simple and informative.

Johand Henriques on 7/2/2010

Why whould u need to understand the accent, when the info is showed on screen in a good way... anyways i understood everything he said..

Christian Bahnsen on 7/2/2010

Nice job. The two videos complement each other. Keep up the good work.

Larry Blackford on 7/2/2010

Thanks for the video, well defined and explained

4A5ADA4D6E on 7/2/2010

Good to know... :-D

huruy yohannes on 7/2/2010

his accent is fine. can hear him v. well. Question, do the columns must be named the same for the except to work?

mark on 7/2/2010

cool. should have mentioned other constructs that are utilized to do the same select * from a where id not in b

Leonard Peoples on 7/2/2010

Very nice. Question: Must all returned fields match on both sides? Thanks. peoplesl@co.kern.ca.us

Elaine Cormier on 7/2/2010

Very well explained, especially with the different examples.

rungsree on 7/2/2010

can you compare using intersect & except to using join & left join in terms of efficiency when dealing with large amount of data? which method is better and in which situation?

Satyabodhi Densmore on 7/2/2010

How does this relate to NOT EXISTS (subqueries)? What happens when you have multiple EXCEPT operators, as for looking for the exceptions in one table in two other tables.

John on 7/2/2010

Thanks

Tim Bochard on 7/2/2010

Great demonstration, thanks.

dosberg on 7/3/2010

I learned something completely new. Thank you.

Mohammad on 7/3/2010

nice and thanks

Neelesh on 7/5/2010

Good one, I like it....expecting more. Thanks,

suman on 7/5/2010

Good one..thanks

Nabhirai on 7/6/2010

Good one thanks alot.

Don Weigend on 7/6/2010

The EXCEPT clause seems more useful to me than the INTERSECT clause. However, both are really great additions to T-SQL! Good explanation on both, thank you!

James Elliott on 7/7/2010

Marco, again I had no problem understanding your presentation. Great job on both video explaining INTERSECT and EXCEPT operators. Keep up the good work it is very much appreciated.

Eric on 7/7/2010

Very concise and to the point. I liked it.

Ananta Das on 8/5/2010

Really simple and strong. I liked it very much.

Mahesh on 8/8/2010

usefull..didn't really new this function existed..thanks for sharing

Steve Culshaw on 8/25/2010

Initially thought the video resolution was going to be a problem, but the zoom in was find Nice touch with the highlighting of results Would have been better to have the two source tables displayed at the same time as the results

Rene Rodriguez on 11/24/2010

Presented very well.

Sam Schafer on 2/4/2011

Once again, the examples are simple and easy to follow - they clearly demonstrate what EXCEPT is intended for. Well done.