• Interests: speak Canadian French

User-Defined string Functions SQLCLR MS SQL 2005

User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net) 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 […]

5 (1)

2007-06-04 (first published: )

627 reads

User-Defined string Functions Transact-SQL

GETWORDCOUNT, GETWORDNUM, AT, RAT, OCCURS,CHRTRAN, STRFILTER, PADC, PADR, PADL, PROPER, RCHARINDEX etc. AT, PADL, PADR, CHRTRAN, PROPER are similar to functions Oracle PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. In my humble opinion, it will be convinient to apply such functions for writing of stored procedures and User-Defined Functions on Transact-SQL. Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115

2006-01-10 (first published: )

1,347 reads

Blogs

Daily Coping 5 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

BUY UNDETECTABLE COUNTERFEIT MONEY(counterfeitmoney414@gmail.com)

By casey4141

MONEY TEAM BANKNOTES IS THE BEST SELLER OF COUNTERFEIT BANKNOTES . We are the...

cheap hennessy

By bion

Are you looking for quality Wine, Champagn,Hennessy or Heineken for your birth day party,wedding,events...

is Forced Parameterization usually more beneficial than less?

By VoldemarG

On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers