Problem solve Get help with specific problems with your technologies, process and projects.

Addressing common SQL Server questions

SQL Server, like any software development topic, lends itself to frequently asked questions. Here we link to a compilation of common SQL FAQs from sister site

SQL Server, like any software development topic, lends itself to frequently asked questions; in this case they tend to revolve around rows, columns and manipulating the data in said rows and columns.

Recognizing this abundance of FAQs, sister site, which gets its fair share of SQL questions, recently posted a three-part series highlighting common questions its site experts have addressed through the years.

  • Common SQL Server questions, part 1 addresses "novice questions" -- for example, the difference between inner and outer joins, between functions and procedures, and between JOIN and SUB-QUERY. While some may laugh at the simplicity of these questions, it helps to remember that very few are born experts.
  • Common SQL Server questions, part 2 looks at "homework questions." These tend to go unanswered since, well, university homework is usually not meant to be done with the help of experienced industry experts, but every once in a while something compelling, and therefore relevant to the SQL developer community at large, does come up.
  • Common SQL Server questions, part 3 examines "serious questions." Some, admittedly, come from homework, but many pop up in the proverbial real world. These tend to involve duplicates, pagination, concatenation, or what the experts have deemed "Top N." read on and it will make sense.

    More on SQL Server development from

    Book Excerpt:Retrieve data from a SQL Server 2005 table
    Book Excerpt: Introducing SQL Server 2005 Reporting Services
    Tip: WinForms development using SQL Server 2005 and Visual Basic 2005
    Tip: Configuring ASP.NET 2.0 apps to SQL Server 2005 databases

  • Dig Deeper on SQL Server and .NET development

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.