As a few people have mentioned, this is fairly easy to accomplish with a Regular Expression. The following pattern identifies the variations found in your data with respect to being...

cmartel 20772 (9/12/2016)

---

My database already contains a few CLR functions (string aggregation and string manipulation functions) that run fast and well.

I would like to create a «MyCurrency» user defined type...

Sergiy (8/29/2016)

---

To make it really painful:

DECLARE @Amount MONEY, @Term INT

DECLARE @fRate float, @dRate decimal (38,28)

SELECT @Amount = 1000000, @Term = 17*3*13*7*19*23*43*11

SELECT @fRate = CONVERT(FLOAT, @Amount)/@Term,

@dRate = CONVERT(DECIMAL(38,28), @Amount)/@Term

SELECT @fRate [@fRate],...

h.tobisch (8/24/2016)

---

set arithabort off

set ansi_warnings on

declare @i int = 1 / 0

declare @j-2 int = 1

set @j-2 = 1/0

select [@i]=@i , [@j]=@j --> yields @i =...

h.tobisch (8/24/2016)

---

It is not true that ANSI WARNINGS OFF generates a result of NULL on zero divide.

Moreover - there is no result generated at all.

What happens is that...

More specifically, SQL Server...

Kevin Gill (8/23/2016)

---

You've confirmed my understanding of sp_configure which I then think means it would be worth a clarification in your article in the section headed "How to configure ANSI_WARNINGS...

If the goal is simply to avoid the warnings for aggregate operations, that can be handled via ISNULL rather than SET ANSI_WARNINGS OFF:

SELECT SUM(tmp.val) AS [SomeSUM]

FROM (VALUES (1),...

This script does not actually list all objects since User-Defined Types are not included. Please see my answer on Stack Overflow for a script that lists all SQLCLR objects:

http://stackoverflow.com/questions/3155542/sql-server-how-to-list-all-clr-functions-procedures-objects-for-assembly/4768899#4768899

Also, I...

Lynn Pettis (8/12/2016)

---

We aren't exactly sure. Some of them are from copy/paste from other sources into our application, some we have no idea at this point and are continuing...

Lynn Pettis (8/9/2016)

---

Actually the upper ranges are being converted to '&#NNNNN;' where NNNNN is the numeric value of the Unicode character.

Here is the itvf I created for the first 53...

Lynn Pettis (8/9/2016)

---

Actually, we have identified 6453 plus a few more (actual count I don't remember at the moment). Basically, converting to a space for the lower control codes...

Lynn Pettis (7/18/2016)

---

Still turns out there may be a limit to the number of replaces you can nest. Originally I was looking at 53 different characters, now it that...

Good and interesting question. Here are some notes regarding the explanation of the answer, as copied here:

Due to an odd behaviour that is not described at https://msdn.microsoft.com/en-us/library/ms175874.aspx, SQL...

The strategy described in the post by Michael J Swart that you linked to is what I have described in detail in the following SSC article: Restructure 100 Million Row...