Novick Software
SQL Server Consulting Design Programming Tuning

  andy novick is a sql server mvp

 

 

The SQL Server Transact-SQL User-Defined Function of the Week

This newsletter has been renamed.  It's now the Coding-in-SQL Newsletter.  Follow the link to the archives below for the back issues.  If you're already a subscriber, you don't have to do anything.  To become a subscriber (it's free) go to the signup page.

Each issue of the T-SQL UDF of the Week newsletter brings you a new CREATE FUNCTION script or an article related to User-Defined Functions.

Although User-Defined Functions (UDFs) have been available in other database management systems for many years, they were only added to SQL Server in SQL Server 2000.  UDFs bring to the developer and DBA unique opportunities for simplifying and reusing Transact-SQL code.

The functions create in the newsletter cover topics like:

  • Text Manipulation

  • Date and Time calculations

  • Unit System Conversions

  • Banking Calculations

  • Disk Space Management

  • Security

  • Management of Traces

  • Metadata reports

  • System UDFs

  • Name and Address Management
  • Enforcing SQL Standards
  • Undocumented System UDFs
Sign Up for the Newsletter

 View the Archives

 UDF FAQ 

 
       


RSS as HTML

Personal Blog

 
New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule