Sunday, September 29, 2013

DIFFERENCE BETWEEN "INSERT INTO" AND UNION IN SQL


Hi SB!


Sure do oblige your presenting the main difference! So I guess with different data structures existing and duplicates to be checked out I'll have to continue with "INSERT INTO"!


Thanx again buddy!




Best Regards, Faraz A Qureshi



Nope, Insert Into also doesn't check it and doesn't even give unique rows.


If you want unique rows, you should UNION instead of UNION ALL.




Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


No comments:

Post a Comment