SQLServerCentral.com Articles tagged UDF

Rendering PDFs Natively in SQL

Wed, 08 May 2013 06:00:00 UT

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Deploying CLR Assemblies with T-SQL

Tue, 07 May 2013 06:00:00 UT

Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.

SQL Code Reuse: Teaching a Dog New Tricks

Mon, 26 Sep 2011 06:00:00 UT

Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.

How to use temporary table in function

Thu, 21 Jul 2011 06:00:00 UT

See a short and dirty example how to use temporary table in user defined function (UDF).

SQL Validation Functions - 4 Cool UDF's to have handy

Thu, 07 Apr 2011 06:00:00 UT

Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...

Creating User-Defined Functions in Microsoft SQL Server

Tue, 28 Sep 2010 06:00:00 UT

SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.

Fun with business days, calendar tables, and test-driven development

Thu, 23 Sep 2010 06:00:00 UT

We shall discuss how to build a calendar table, and use it in calculations involving business days

4-4-5 Calendar Functions, Part 1

Mon, 06 Sep 2010 06:00:00 UT

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.

4-4-5 Calendar Functions, Part 2

Mon, 11 Jan 2010 07:00:00 UT

Part 2 showing how to get the Period in a 4-4-5 Calendar

4-4-5 Calendar Functions, Part 1

Mon, 06 Sep 2010 06:00:00 UT

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.