Post reply

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

  • 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

  • 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".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • 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

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

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