GeekZilla
Articles tagged under clr
CLR Stored Procedure for searching files
CLR Stored Procedure for searching files I was recently asked to write a CLR stored procedure which would process a text file and return a row for each line in the file that contained text matching our search criteria. I'd never written a CLR stored proc before so it was an interesting
Paul Hayman - 16,037 viewsEnabling CLR execution in SQL Server
Enabling CLR execution in SQL Server If you plan to run stored procedures you have written in .NET you will probably need to enable CLR execution on your server. To do this you'll need to run the following T-SQL sp_configure 'clr enabled', 1 GO RECONFIGURE GO
Paul Hayman - 4,503 viewsWriting CLR Stored Procedures in C#
Writing CLR Stored Procedures in C# As SQL Server 2005 rolls out DBA's are going to be forced to learn either C# or Visual Basic or both. Until now these were client side languages and not knowing them had little impact on your job. And if you write code in these languages your going to have
Paul Hayman - 16,022 views