N S

Novick Software
SQL Server Consulting • Design • Programming • Training

  andy novick is a sql server mvp

 

 

Originally presented to New England SQL Server Users Group, January 2003, it's been updated to reflect for the presentation to the New Hampshire SQL Server Users Group in February 2004.

This is an introduction to SQL Server 2000 User-Defined Functions.  It covers:

  • How to create and use the three types of UDFs: scalar, inline and multistatement.  
  • Performance issues are a major part of the discussion.  They can be a problem with a UDF. 
  • Permissions to use UDFs are discussed
  • Additional topics such as  debugging,
  • The system UDFs are discussed:

    fn_virtualfilestats
    fn_trace_*
    fn_get_sql
    and more....

 

You may download the User-Defined Functions Slides  or Download sample database and script of User-Defined Function presentation.

 


RSS as HTML

Personal Blog

 
New Tips:

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

Upcoming
Presentations:

Fairfield
Westchstr
SQL

July 8
Data Dude
 

RI SQL
July 14
SQL Azure


Full Schedule