Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
SQLCLR
Items 1 to 14 of 14
Exporting to Excel Using a CLR Stored Procedure
The inclusion of the CLR in SQL Server has been controversial, but some people have come up with great ways to take advantage of this feature. New author Anders Pedersen brings us a technique to export data from SQL Server into Excel using the CLR.
Read more...
By
Anders Pedersen
2009/12/02
|
Source:
SQLServerCentral.com
|
Category:
sqlclr
Rating:
|
Discuss
|
Briefcase
|
15,264 reads
Introduction to Bitmasking in SQL Server, Part 2
In part 2 of his series, Lee Everest expands upon bitmasking and integrates this with the SQL CLR.
Read more...
By
Lee Everest
2009/05/21
|
Source:
SQLServerCentral.com
|
Category:
bit masking
Rating:
|
Discuss
|
Briefcase
|
6,563 reads
Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files
Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.
Read more...
By
Jonathan Kehayias
2009/03/03
|
Source:
SQLServerCentral.com
|
Category:
sqlclr
Rating:
|
Discuss
|
Briefcase
|
7,709 reads
SQL Server CLR function to concatenate values in a column
If a column is normalized, but the user really wants to see the values as a short comma separated list, how can I write a query that produces the list? Concatenating the values in a column would be pretty easy if SQL Server had a concatenate aggregate function, which it doesn't. What's more, for efficiency sake it's important to write the reporting queries without using cursors.
Read more...
By
Additional Articles
2009/02/09
|
Source:
MSSQLTips.com
|
Category:
sqlclr
Rating:
(not yet rated)
Rate this
|
Briefcase
|
398 reads
Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents
Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers.
Read more...
By
Jonathan Kehayias
2009/02/05
|
Source:
SQLServerCentral.com
|
Category:
sqlclr
Rating:
|
Discuss
|
Briefcase
|
11,605 reads
SQL Server CLR function to improve performance of validating email addresses
I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?
Read more...
By
Additional Articles
2009/02/03
|
Source:
MSSQLTips.com
|
Category:
sqlclr
Rating:
Rate this
|
Briefcase
|
2,663 reads
Writing to an operating system file using the SQL Server SQLCLR
Reading files from the operating system can be done with T-SQL as I showed in the tip Using OPENROWSET to read large files into SQL Server. What if you want to write to an operating system file? For example, writing to a text file. There's no T-SQL that supports writing to a file.
Read more...
By
Additional Articles
2009/01/21
|
Source:
MSSQLTips.com
|
Category:
sqlclr
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,089 reads
Processing XML Showplans Using SQLCLR in SQL Server 2005
Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.
Read more...
By
Additional Articles
2008/08/08
|
Source:
TechNet
|
Category:
showplan
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,899 reads
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.
Read more...
By
Additional Articles
2008/07/04
|
Source:
TechNet
|
Category:
sqlclr
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,133 reads
How To Return a Result Set from a SQL Server 2005 CLR Stored Procedure
We occasionally come up with a requirement that would be a good fit for a CLR function or stored procedure. For instance we would like to call a stored procedure to get the list of files in a particular folder. How can we return the list of files as a standard result set (i.e. rows and columns) using the CLR?
Read more...
By
Additional Articles
2008/06/30
|
Source:
MSSQLTips.com
|
Category:
sqlclr
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,755 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
|
4,796 reads
CLR Assemblies
Read more...
By
Site Owners
2008/06/19
|
Category:
sqlclr
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,839 reads
DMVs
Read more...
By
Site Owners
2008/06/02
|
Category:
sqlclr
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,692 reads
SQL Server 2005
Read more...
By
ginni.sinha
2008/04/02
|
Category:
sql server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,673 reads
Items 1 to 14 of 14
Tags
sql server 2005
(2)
ado.net
(1)
backup
(1)
bcp
(1)
bit masking
(1)
bit masking using c#
(1)
common language runtime (clr)
(1)
data validation
(1)
disaster recovery
(1)
excel
(1)
export
(1)
showplan
(1)
sqlclr and bitmask
(1)
string manipulation
(1)
xml
(1)
xp_cmdshell
(1)
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use