Stairway to Advanced T-SQL Level 10: Using Scalar Functions

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  October 8, 2020 at 10:42 pm

  #3794261

  Comments posted to this topic are about the item Stairway to Advanced T-SQL Level 10: Using Scalar Functions

  Gregory A. Larsen, MVP

• Jeff Moden

  SSC Guru

  Points: 1004621

  More actions

  October 9, 2020 at 1:39 pm

  #3795484

  I've not read this entire article but there does seem to be a problem... for example, this is a quote from the article...

  When I ran the code in Listing 6, it produced the results found in 1.

  Figure 1: Results when executing code in Listing 1

  By reviewing the results in Figure 1, you can see that the current date/time was displayed as a DATETIME data type value.

  The thing is, there is no "Figure 1" 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.

  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)
  

• Toby Harman

  SSCarpal Tunnel

  Points: 4171

  More actions

  October 21, 2020 at 7:58 am

  #3799599

  No mention of using schemabinding on scalar functions that don't actually touch the database. This can provide a significant performance benefit by removing  the unnecessary Halloween protection