I am lazier: 😉

declare @q varchar(1) = CHAR(39)

An Irish syndrome - introducing Mr and Mrs O'Brien 😎

Well, apostrophe was at least something you could predict and prevent - as soon as you knew it...

Yes, I agree - but you could use a wrapper SP to catch an exception (RUSSIAN DOLLs model :-))

Thank you for a great article!

I am not quite agree with this statement "SQL Server has no specific functions or methods for validating XML".

How about strongly typed XML parameter...

Well done,

I had a similar challenge during data migration, my solution was by splitting character-delimited values with XQUERY and applying transformation across a whole table.

Geoff A (7/19/2013)

---

fregatepallada (7/19/2013)

---

Guys, did somebody mention this 😉 (valid only in SQL Server 2012):

-- Current date

DECLARE @d DATETIME = GETDATE();

SELECT FORMAT( @d, 'dd MMM yyyy', 'en-US' ) AS...

Bruce W Cassidy (3/2/2013)

---

All I can say to that is that it's a good thing that SQL isn't intended to be a parser, and thus we don't have to worry...

Sean Lange (3/1/2013)

---

Jeff Moden (3/1/2013)

---

Sean Lange (3/1/2013)

---

Irozenberg 1347 (3/1/2013)

---

Elementary sub-query or EXISTS clause would

Radically improve performance.

If you like fancy coding you could pass XML as

parameter and use XQUERY....

Elementary sub-query or EXISTS clause would

Radically improve performance.

If you like fancy coding you could pass XML as

parameter and use XQUERY.

IMHO dynamic SQL outside of database is a recepie for a disaster.

Anybody hear about SQL injection in last 15+ years?

Why not use parameterised stored procedures/user-defined functions.

I would...

Why we have to be inventive and create such acrobatic solution in a first place? Just to compensate for bad design and implementation decisions.

If original DB developers did not...

Speaking of garbage in - garbage out. In case when I have to split a CSV into a list of items I spend at least one hour trying to understand...

RIP Mars Climate Orbiter(formerly the Mars Surveyor '98 Orbiter)

The metric mixup error

The MCO MIB has determined that the root cause for the loss of the MCO spacecraft was the failure...