<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
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
Refine your search with one of the following additional tags (with number of items):
SQL Server 2005
(2)
Bit Masking
(1)
Disaster Recovery
(1)
String Manipulation
(1)
ADO.NET
(1)
bit masking using c#
(1)
Export
(1)
XML
(1)
Backup
(1)
Common Language Runtime (CLR)
(1)
Showplan
(1)
xp_cmdshell
(1)
BCP
(1)
data validation
(1)
sqlclr and bitmask
(1)
Items 1 to 13 of 13
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,395 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,404 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
|
277 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,113 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,555 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
|
2,966 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,811 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,082 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,616 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,717 reads
CLR Assemblies
Read more...
By
Site Owners
2008/06/19
|
Category:
SQLCLR
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,814 reads
DMVs
Read more...
By
Site Owners
2008/06/02
|
Category:
SQLCLR
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,671 reads
SQL Server 2005
Read more...
By
ginni.sinha
2008/04/02
|
Category:
SQL Server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,630 reads
Items 1 to 13 of 13
Most popular
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,113 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,395 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,404 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
