Problems Solved

Problems Solved

Level 16 Errors Can’t always be handled by User Code August 13, 2014 Although books-OnLine says that user code can handle errors with Level 16 and below, they sometimes end the connection.
Read More

Retrieving a Random Record in SQL Server using udf_Num_RanInt August 1, 2014 This UDFs week solves a problem posed to me last week by a friend Gary.  Gary wants to select a random row from one of his tables and was hoping that SQL Server would have some support for this task.
The idea of selecting a random row runs counter to the ideas that are the basis of the … Read More

The Problem with User-Defined Functions (UDF) and a Solution May 22, 2014 Download the sample script: Problem-Scalar-UDF-and-solution-andy-novick   and a PDF of the slides: The Problem with scalar UDFs and a solution – Andy Novick Or watch the video on Youtube:
https://www.youtube.com/watch?v=OAdFQm7Pt-w
 
User-Defined functions (UDF) have been around SQL Server since the 2000 version. They are a great way to encapsulate business logic in a reusable form.  There are there types of … Read More