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 8 of 8   
 

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 14,820 reads

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,403 reads

Visibility

By Steve Jones 2013/09/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,437 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,261 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,597 reads

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 14,820 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,424 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,103 reads
   Items 1 to 8 of 8   
 
Tags
.net (1)    
administration (1)    
assembly (1)    
async (1)    
c# (1)    
common language runtime (clr) (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 clr (1)    
sql server (1)    
sql server 2005 (1)    
stored procedures (1)    
stream (1)    
string manipulation (1)    
tables (1)    
udf (1)    
utility (1)