simple TSQL Querying tutorial?

• Eric Mamet

  SSChampion

  Points: 11728

  More actions

  May 12, 2008 at 9:37 am

  #185397

  Dear all,

  I have been asked to organise a simple TSQL Presentation/Tutorial for our Testers.

  I have been using "SELECT ..." for more than 20 years and I don't remember how it felt to learn this...

  Would you happen to know where I could find a (very) simple tutorial or presentation I could go through with my testers?

  Many Thanks

  Eric 😉

• Rick Burrows

  SSC Enthusiast

  Points: 151

  More actions

  May 12, 2008 at 1:21 pm

  #814035

  How about http://www.w3schools.com/sql/default.asp

  Lots of good stuff there, not just SQL

• Jeff Moden

  SSC Guru

  Points: 1004403

  More actions

  May 12, 2008 at 10:00 pm

  #814211

  I'll second that... just remember that they teach ANSI SQL... nothing really advanced.

  --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.

  Change is inevitable... Change for the better is not.
  

  ---

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

• Eric Mamet

  SSChampion

  Points: 11728

  More actions

  May 13, 2008 at 2:51 am

  #814293

  I had forgotten about this one...

  Yes, it sounds a very good idea

  Thanks 🙂