Having spent far too long in hindsight trying to find these templates for some work on functions and regular expressions I gave up and installed the express version of Visual Studio 2010.
FYI, using the command line to populate the default templates doesn't work as described here.
So why am I doing this, a new role where SQL and .net are the sole available languages got me thinking of how to implement data cleansing routines from perl in SQL.
The appendix in this book Inside Microsoft SQL Server 2008: T-SQL Programming gives you the VB code you need which is a great place to start to learn intermediate techniques such as user defined functions and CLR assemblies.
CLR Assemblies allow you to incorporate Regular Expressions into SQL which can be used to verify email address structures and are the basis of data cleaning.
