What is the difference between UNION and UNION All ( SQl server )?. This is a important SQL server interview question. The UNION and UNION ALL keywords are both set operators, meaning they work with sets of data.They are used to combine two result sets into one