Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag SQLCLR Rss

Search for any content tagged sqlclr

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets. Solution Expose the C# Hashbytes function using CLR  Read more...
By Simon Hundleby 2015/12/01 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 759 reads

List CLR Objects in Database

Script lists all the clr objects in the database.  Read more...
By Harsha Majety 2016/08/23 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,215 reads

T-SQL CLR to query session hostname

This code allows you to query hostname of each session on your database.  Read more...
By Jason S Wong 2012/06/01 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 863 reads

CLR Aggregate to Concatenate delimited strings

One must be carefull unless the input is sorted by the value passed to the function and there is no paralelism there is no guarantee that the resulting value will be sorted.  Read more...
By Gokhan Varol 2011/01/27 | Source: | Category: string
Rating: (not yet rated) |  Discuss |   Briefcase | 817 reads

SQL CLR Function for Email validation and string Split

I have added 2 functions here, one for email validation and another to split the string by specified separator by user.  Read more...
By Bharat Panthee 2010/12/23 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,479 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,121 reads
   Items 1 to 6 of 6