N S

Novick Software Management • Design • Programming • Training • Consulting

   

 

 

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:

Loading SQL Profiler trace (.trc) files with fn_trace_gettrace
Upcoming
Presentations:

Big Data:
Working with Terabytes
in SQL Server
July 9 '08

Full Schedule