October 8, 2020 at 10:42 pm
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
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
Change is inevitable... Change for the better is not.
October 21, 2020 at 7:58 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy