What are the basic rules to be followed when you are using SQL SET Operators? Posted in SQL Interview Questions by Chandrasekhar Raparthi On July 10, 2014. No comments Rules: Number of columns in all the result sets should be matched(same). Respective data types should be matched between all the result sets. Share this:GooglePinterestEmailTwitterLinkedInFacebook Tags:set operators,SQL Related Posts How do you generate the sequence of dates from one date to other? This is possible through Recursive CTEs. You can execute What is Self join and why do we need it? There is no special type of join called Self What are the types of Triggers available in SQL Server? Types of Triggers: DDL Triggers DML Triggers After Triggers Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed.