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 What is the difference between REPLACE() and STUFF() functions? REPLACE() It is used to replace all the occurrences of How to extract alphanumeric characters from a string? This is possible by using the combination of PATINDEX() What is meant by the error ‘String or binary data would be truncated. The statement has been terminated’? String or binary data would be truncated This is 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.