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 a Transaction and explain the types in it. Transaction: A Transaction is a group of SQL statements 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 How to extract alphanumeric characters from a string? This is possible by using the combination of PATINDEX() 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.