Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, SQLCLR Rss

   Items 1 to 7 of 7   
 

SQL CLR Multi-Threaded File Copy

A CLR Procedure that performs multi-threaded fie copies without external command line tools.  Read more...
By Steve Ledridge 2013/11/19 | Source: SQLServerCentral.com | Category: async
Rating: |  Discuss |   Briefcase | 2,329 reads

Visibility

By Steve Jones 2013/09/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,407 reads

How to Compile, Deploy and Consume a SQL Server CLR Assembly

Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.  Read more...
By Stan Kulp 2013/08/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,036 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2013/05/08 | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 15,512 reads

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2012/12/06 | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 8,853 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,402 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: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,092 reads
   Items 1 to 7 of 7   
 
Tags
.net (1)    
administration (1)    
assembly (1)    
async (1)    
c# (1)    
common language runtime (1)    
cryptography (1)    
file copy (1)    
indexed views (1)    
maintenance and management (1)    
mssql (1)    
multi threaded (1)    
pdf (1)    
pivot (1)    
render (1)    
search (1)    
sql (1)    
sql clr (1)    
sql server (1)    
sql server 2005 (1)    
stored procedures (1)    
stream (1)    
string manipulation (1)    
tables (1)    
udf (1)    
utility (1)