Welcome to SqlAdvice Sign in | Join | Help

July 2007 - Posts

Thursday, July 26, 2007 8:03 AM

SQL Server 2005 Templates

I have found the SQL Server 2005 templates to be extremely useful. I have created custom templates for creating a new stored procedure, scalar functions, table-value functions and views. The benefit of these is that it creates a standard for creating
Posted by gstark | 2 Comments
Wednesday, July 18, 2007 11:07 PM

Sql Server Cursor Template

This is a template that I have been using in SQL server for when I do have to write cursors. Notice that there is only one fetch statement in there which is much slicker than the typical method of initially doing a fetch, with a while condition of while
Posted by gstark | 1 Comments
Filed under: , ,
Wednesday, July 18, 2007 1:59 PM

Enable CLR and Unsafe Assemblies SQL Server 2005

Since I can never remember this off the top of my head I figured I would post on my blog. To enable the use of CLR on SQL Server run the following.... EXEC sp_configure ' show advanced options ' , ' 1 ' ; go reconfigure ; go EXEC sp_configure ' clr enabled
Posted by gstark | 0 Comments