External Article

Remove HTML tags from strings using the SQL Server CLR

  • Article

It is recommended that you remove all special characters and HTML formatting. This task can be handled in TSQL code, however in this case I have the opportunity to use .NET and the power of the regular expressions to manage the string. In this tip, I'll build a CLR function which cleans up a string of HTML tags and special characters. I'll use Visual Studio 2010 with C# as the programming language. Check out this tip for my solution.


3,902 reads

External Article

Read and Write Binary Files in SQL Server with CLR

  • Article

You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.


4,324 reads

External Article

SQL Server random numerics data generation using CLR

  • Article

You need to generate random data directly into SQL Server table columns or close to the database engine as variables or expressions. Looking at the SQL Server available functions, you notice that only RAND function offers support for random data generation. Although RAND([seed]) is a built-in function, it can only return a float value between 0 and 1, and has other limitations in regards to seed values. Because your table columns may be of various data types, and each data type may have a lower value and an upper value, you would prefer to create your custom random data generators. This is when SQL Server CLR functions come into play and provide a viable solution.


3,275 reads


Updates from Coping Tips


I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

What I’ve learned in my first 100 days with a consulting group


In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?


With Power BI continuing to get many great new features, including the latest in...

Read the latest Blogs


What's your opinion about Google Cloud SQL?

By mavalgreb

Hi, I wonder what your opinion about Google Cloud SQL is! We are a...

How To Flatten JSON Data?

By Chris Wooding

I receive data in JSON files and for one particular type of data I...

Last Cube Refresh Showing Wrong Time

By Shivs

Hi I have a tabular model and have been asked to retrieve the last...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers