• Interests: speak Canadian French

Technical Article

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)

You rated this post out of 5. Change rating

2007-06-04 (first published: )

661 reads

Technical Article

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

You rated this post out of 5. Change rating

2006-01-10 (first published: )

1,555 reads

Blogs

Designing for Observability in Fabric Powered Data Ecosystems

By

In today’s data-driven world, observability is not an optional add-on but a foundational principle....

SQL Server 2025 Unleashed Live Training – A New Era Begins

By

I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...

Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition

By

In my previous post, I showed you how to build a snapshot backup catalog...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Connecting to SQL express 2019 server

By waltthrombey

Hello, Our old server is on its last legs, and I'm transitioning to a...

Docker Advice for SQL Server in Production

By Vincent92

Comments posted to this topic are about the item Docker Advice for SQL Server...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers