Microsoft SharePoint Team Blog
The official blog of the Microsoft SharePoint Product Group

SQL Expressions

Introduction to Functions


Functions Fundamentals


Introduction


A function is a relatively small task that should be performed aside but can be accessed any time to give a result. In Transact-SQL, a function is considered an object. Based on this, you must create a function and execute it before using it. The function then becomes part of a database and it can be accessed.

Practical Learning: Introducing Functions



Make sure you have a user account named pkatts (created in Lesson 1).
Make sure you created a login for the pkatts account (created in Lesson 3).
Start the SQL Server Management Studio
To create a new database, right-click Databases and click New Database...
In the Name text box, type RealEstate1
Set the owner to ComputerName\pkatts (Windows XP or Vista) or DomainName\pkatts (Windows Server)
Set the Paths to C:\Microsoft SQL Server Database Development
Click OK
In the Object Explorer, Expand the Databases node followed by the RealEstate1 node
Under RealEstate1, right-click Security, position the mouse on New, and click Schema...





source : http://blogs.msdn.com/sharepoint/default.aspx