What the most significant condition to use SQL CLR?

Question

What the most significant condition to use SQL CLR?

Qira

SSCommitted

Points: 1930
More actions
September 4, 2014 at 8:09 am

#310691

I'm a newbies develop SQL CLR. My question - What the most significant condition to use SQL CLR?
I need to know SQL CLR should be use instead T-SQL.
Exporting a query to disk: TXT/CSV/TSV/RTF/HTML/DOC/XLS/More format's than you care to know.
alternatively, return the same file formats above as varbinary to store in the database.
regular expresisons
file system operations on the server(file exists, directory exists)
PGP encryption
Validating Email Addresses
Calling Specific Web Services
Reading Web Page/Returning raw html

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Emil B SSCertifiable Points: 5568 More actions · Answer 1

Hi Quira,

please refere to the stairway to SQLCLR 1. i think it answers your question

http://www.sqlservercentral.com/articles/SQLCLR/104406/[/url]

Lowell SSC Guru Points: 323518 More actions · Answer 2

i use CLR extensively, and for a lot of different reasons.

Here's a list of the things i use it for:

vagabondsw Grasshopper Points: 22 More actions · Answer 3

I have used the CLR once before on a previous job.

I was working for a game company, and we had two development groups; game developers and website developers. I was on the web team and created the subscription and payment functionality using external web services provided by various vendors. I was using C# and the .NET framework to create this functionality.

The game developers were using Native C++ to write the game. They did not have a C++ module to consume a web service, but they did have a C++ module to consume a Stored Procedure.

So I wrote a SQL CLR stored procedure that called the various web services and contained all the business logic. This meant the user saw the same result whether they viewed the information form within the game or on the web site.