[OT] UDFs MS SQL Server 2005 Transact-SQL CLR C#.Net

[OT] UDFs MS SQL Server 2005 Transact-SQL CLR C#.Net

Post by SWdvciBOaW » Wed, 08 Mar 2006 05:38:43


Ladies and Gentlemen,

I am pleased to offer, free of charge, the following string functions MS SQL
Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net):

AT(): Returns the beginning numeric position of the nth occurrence of a
character expression within another character expression, counting from the
leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a
character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within
another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within
another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or
characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or
characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a
character in a second character expression with the corresponding character
in a third character expression.
STRTRAN(): Searches a character expression for occurrences of a second
character expression, and then replaces each occurrence with a third
character expression. Unlike a built-in function Replace, STRTRAN has three
additional parameters.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
GETALLWORDS(): Inserts the words from a string into the table.
PROPER(): Returns from a character expression a string capitalized as
appropriate for proper names.
RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right
search.
ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified
numeric expression (from 1 to 3999).
ROMANTOARAB(): Returns the number equivalent of a specified character Roman
numeral expression (from I to MMMCMXCIX).

AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP.

Plus, there are CHM files in English, French, Spanish, German and Russian.

Plus, there are versions for MS SQL SERVER, SYBASE ASA, DB2, Oracle.

More than 8000 people have already downloaded my functions. I hope you will
find them useful as well.

For more information about string UDFs MS SQL Server 2005 Transact-SQL
SQLCLR (VB. Net, C#.Net, C++. Net) please visit the
http://www.yqcomputer.com/ ~2,54,33,29527

Please, download the file
http://www.yqcomputer.com/ ~2,2,29527

With the best regards.
 
 
 

1. SQL Server 2005 Beta 2 Transact-SQL Enhancement

2. T-SQL vs. CLR/C# in SQL Server 2005

Has anyone tried to use C# or another .NET language as the primary database
programming language?

What I have seen regarding performance is that C# stored procedures perform
at least twice as slow as their T-SQL equivalents. I've ensured that test
cases are simple (e.g., select newid()) wrapped as C# and T-SQL stored
procedures. Perhaps this is because .NET CLR procedure implementations treat
SQL as dynamic. Could this be true? How are database connections managed in
C#? Are C# stored procs executed in the same memory space as T-SQL procedures?

What are the primary performance impacts of C# vs. T-SQL?

Thanks,
Tom

3. How to create a C# clr dll to use in sql server 2005 with vs 2005?

4. SQL Server Chat next Tuesday: SQL Server 2005 Beta 2 CLR Q & A

5. SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

6. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000

7. String UDFs Transact-SQL

8. Debugging SQL Server 2005 Transact SQL

9. SQL Server 2005: CLR functions vs SQL functions

10. Running Transact-SQL script from SQL server agent with a different

11. SQL Server 2005, .Net / CLR Support and Event Handling

12. Running Transact-SQL script from SQL server agent with a different account

13. sql session state for .net v1.1/.net v2.0 and sql server 2005

14. Running Transact-SQL script from SQL server agent with a diffe