Welcome to our new technology posting blog – now on WordPress. Wordpress has some nice widgets for blogging (pressing) from pretty much anywhere and subscriptions are more straightforward t0o (you don’t have to subscribe separately to comments). Please post all your awesome tech article finds here along with other technology ideas that affect our product development and maintenance. Make the blog more interactive and fun for everyone by commenting on the posts of others. Got a client deadline coming up? Let everyone know by posting it on the calendar – use the “countdown” widget for a more dramatic effect.
The less loopy the better! I have been using tally tables for a couple of years now but this article really expanded my understanding of how the technique can be applied more broadly. An excellent article – great post Ted! If you still use a lot of loops or cursors in your TSQL code you’re out of touch with best practices. Tally tables, CTE’s (common table expressions), MERGE and “update X” statements are well established methods to convert loops to set based operations and are fundamental skills expected of mid-level TSQL developers. If you don’t have these in your repertoire now, do some reading and find ways to apply these techniques in your very next TSQL coding assignment.
Originally posted on synoptec DEV:
There is a specific syntax TSQL provides for skipping function execution when any parameters are NULL. This often cleans-up code that would otherwise have to use branching logic to avoid the execution. Fast, simple, and handy.
CREATE FUNCTION dbo.fMyFunction
) returns bit with returns null on null input