capabilities of T-SQL
Full Version Free Version Documentation
SQL CLR Library , SQLCLR , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements , Median , Automation
-- Benefits --
You have the task of doing somewhat complex operations at the database level, right?
That's right folks, SQL# will help cure your T-SQL blues.
But seriously now, consider this:
SQL# is a small but extensive library of useful functions to help you code more powerful SQL Stored Procedures and User-Defined Functions. For too long now T-SQL has not given the SQL programmer enough flexibility to code complex logic, at least not without going through the pain of creating a DLL and registering it as an Extended Stored Procedure (xp):
In previous versions of SQL Server, developers could extend SQL Server functionality by
writing extended stored procedures. Writing high-quality extended stored procedures
requires a strong knowledge of the Open Data Services (ODS) library and the poorly documented
C-style Extended Stored Procedure API. Anyone who's ever attempted the old
style of extended stored procedure programming can tell you it's a complex undertaking,
where a single misstep can easily result in memory leaks and/or corruption of the SQL
Server process space. Also the threading model used by extended stored procedures
requires SQL Server to rely on the operating system to control threading and concurrency.
This can also lead to issues, such as unresponsiveness of extended stored
But now, FINALLY, SQL# (SQLsharp) gives the T-SQL programmer and SQL Server DBA the programatic tools that previously only application developers had at their disposal. It wasn't fair that application developers had so many commands to use and yet SQL developers had but a few and had to spend too much time use those few commands to create functions to emulate the commands available in real programming languages. SQL# evens the playing-field by giving T-SQL programmers what we have been wanting for so long now. SQL# provides most of the commonly used, empowering, and time-saving commands available in the .Net languages and even some custom utilities to make life easier. So stop wasting time recreating the wheel and writing that "split" function that thousands of SQL DBAs and programmers have done thousands of times before and start focusing on the business logic that is the your true objective.
Copyright © 2006 - 2013 Solomon Rutzky. All rights reserved.