SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Export, SQLCLR Rss

   Items 1 to 3 of 3   
 

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...
By Bret Lowery 2011/07/18 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,790 reads

XLSExport: A CLR procedure to export proc results to Excel

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...
By Bret Lowery 2011/06/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 8,883 reads

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...
By Solomon Rutzky 2008/06/24 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,203 reads
   Items 1 to 3 of 3   
 
Tags
bcp (2)    
c# (2)    
backup and restore (1)    
bulkcopy (1)    
common language runtime (clr) (1)    
disaster recovery (dr) (1)    
excel (1)    
import (1)    
json (1)    
sql server 2005 (1)