SQL Archives - Page 204 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Simple Puzzle with UNION – Part 5

September 11, 2013

It seems that my yesterday’s Simple Puzzle with UNION intrigued many readers. Here is my fifth and final part of this Puzzles with UNION. I strongly suggest to read yesterday’s puzzle before continuing today’s puzzle as it is very much based on yesterday’s puzzle. SQL SERVER – Simple Puzzle with UNION…

SQL SERVER – Simple Puzzle with UNION – Part 4

September 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Union clause, Union

When I started to write Simple Puzzle with UNION last week, I had no clue this will be extremely popular blog post and will turn into a mini-series. Earlier I wrote three different blog posts on this subject and they are very well received. All the three blog posts which…

SQL SERVER – Simple Puzzle with UNION – Part 3

September 9, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Union clause, Union

Earlier last week I had two simple puzzles related to UNION clause and the response to those puzzles have been amazing. Lots of email I have received that people wants me to post such basics puzzle again. Well here is one more puzzle which uses UNION and tests your basic…

SQL SERVER – Download SQL Server Developer Edition 2012 for USD 60

September 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Server professionals often send me email asking about where can they download the full version of SQL Server for their own development. Microsoft only provides evalution version of its enterprise software (full version). The evaluation version is bound by time and it expires when the time trial is over. This does not…

SQL SERVER – Weekly Series – Memory Lane – #045

September 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – Simple Puzzle with UNION – Part 2

September 6, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Union clause, Union

Yesterday we had very easy kind of Back to Basics Puzzle with UNION and I have received tremendous response to the simple puzzle. Even though there is no giveaway due to sheer interest in the subject, I have received many replies. Due to all the request, here is another back…

SQL SERVER – Simple Puzzle with UNION

September 5, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Union clause, Union

It has been a long time since played a simple game on SQLAuthority.com. Let us play a simple game today. It is very simple puzzle but indeed a fun one. First let us execute following SQL. Query 1: SELECT 1 UNION ALL SELECT 1 ORDER BY 1 It will return…