Level 1: The Basic SELECT Statement

  • Greg Larsen

    SSC-Insane

    Points: 20635

    Comments posted to this topic are about the item Level 1: The Basic SELECT Statement

    Gregory A. Larsen, MVP

  • Mike Palecek

    SSCommitted

    Points: 1560

    Excellent article. I think these stairway articles are a great idea. I know will always benefit from reviewing and learning about the basics. There is ton of features in SQL that make it useful but a solid foundation in the basics is more beneficial than knowing all of the advanced stuff

  • gp3121

    Valued Member

    Points: 64

    As usual a stellar entry -- this stairway concept is invaluable.

    A minor usability complaint... any way to make the code sample windows larger? Maybe it's my browser but they barely display the first word of each line.

    Thanks in any case for these series -- this one in particular will be useful in filling gaps in my understanding, and may well get some of my SQL-phobic coworkers into the water.

  • SQLRNNR

    SSC Guru

    Points: 281205

    Thanks for putting this together.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Paul DB

    SSC Eights!

    Points: 840

    Great article! A minor typo (I think): Exercise #1 refers to "Human.Resources.Employee table". I think it should be "HumanResources.Employee table". What do you think?

    Also I think the Level 3 link should be named "Implementing a Relational Model in SQL Server".

    Cheers!

    Paul DB

  • imaaronacs

    SSC Rookie

    Points: 26

    Hello, I started working on this staircase and noticed the AdventureWorks database was used during the exercises. Which version of adventure works can I get this instance from? i have tried versions 2008,2012, and 2016 and i haven't found exactly the same instance.

    Thanks

  • Jeff Moden

    SSC Guru

    Points: 995113

    imaaronacs - Wednesday, February 6, 2019 7:42 PM

    Hello, I started working on this staircase and noticed the AdventureWorks database was used during the exercises. Which version of adventure works can I get this instance from? i have tried versions 2008,2012, and 2016 and i haven't found exactly the same instance.

    Thanks

    It says which version and even where to get it right in the article.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Greg Larsen

    SSC-Insane

    Points: 20635

    Yes it does, but the SQL Server 2005 version no longer exists.    You could probably change the code to support one of those other versions.

    Gregory A. Larsen, MVP

  • Jeff Moden

    SSC Guru

    Points: 995113

    Good lord.  I clicked on the link and it took me to codeplex, which says that it "is still available" if you click on a certain link which takes you to an archive search which returns nothing, just like you said.

    That's a part of the reason why I always manufacture test data for my articles.  I've seen things like this happen way too often with even 2nd party data samples.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • HappyGeek

    SSCoach

    Points: 18670

    I was a bit curious as to why an 8 year old thread has suddenly become active so had a quick look at my installation of AdventureWorks2014 database, it contains the same schema and tales as used in the article, the provided sample code ran (on the whole) without modification; the only difference that I can see is the reference to EmployeeId and ContactId (within the article) which I believe is now called BusinessEntityId.
    I have not verified against any other version of AdventureWorks HTH.

    ...

  • imaaronacs

    SSC Rookie

    Points: 26

    Couldn't find any instances of Adventure Works 2005 anywhere, tried this website: https://www.microsoft.com/en-us/download/confirmation.aspx?id=10679
    and
    https://archive.codeplex.com/?p=MSFTDBProdSamples

    could any one point me in the direction of the download?

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply