SQL Server Education (by the geeks, for the geeks)
This is a very basic problem sometimes newbies struggle with. I have seen developers writing 10 different insert statements to insert 10 rows in a table. This can be simplified in …
Insert multiple rows using single Insert statement in SQL Server Read MoreDifference between UNION and UNION ALL is one of the most asked interview question. UNION and UNION ALL both combine result set from two or more queries into single result. The …
Difference between UNION and UNION ALL in SQL Server Read MoreHey Geeks, You might have the knowledge of it, but do you know that there’s a difference between this two of them. So I will try to give brief on this: …
SQL Server – Union and Union All, it’s not the same stuff Read More