The Intersect Operator returns us distinct matching records from two or more Select queries ( Result Sets).
For Intersect Operator to work, the Number of columns should be same in all Select queries and data type should match.
Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/04/wh...
Watch video What is Intersect Operator in SQL Server - SQL Server Tutorial / TSQL Tutorial online without registration, duration hours minute second in high quality. This video was added by user TechBrothersIT 06 April 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,552 once and liked it 1 people.