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

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

    Gregory A. Larsen, MVP

  • 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)
    Intro to Tally Tables and Functions

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

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