SQLUSA
 

Microsoft SQL Server 2000

Best Practices

 

How to name user-defined functions?

 

Use the following prefixes: f, fn, function

Examples: fEncodeCreditCardNumber, fnCalculateAverageReturn, functionNextRenewalDate

Usage:

select dbo.fEncodeCreditCardNumber('1111222233334444')

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page