As I mentioned before, often the XML must be interrogated to determine the placement of the inserted node. This sample checks both the XML to be modified and the XML...

The XML modify/insert has 4 positioning directives, as first,as last, after and before, changing from as last to after for the correct positioning, note the slight difference in the syntax.

Often...

Edit: deleted the post

Quick'n simple example

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = '<Attribute>

<A1>6529</A1>

<A2>6529</A2>

</Attribute>';

DECLARE @NNODE VARCHAR(100) = 'A3';

DECLARE @NVAL VARCHAR(100) = 'New value';

DECLARE @Nt ...

Quick solution of the "first coffee in the morning" kind, probably not the most efficient but it works

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.database_tags') IS NOT NULL DROP TABLE dbo.database_tags;

create table...

KoldCoffee (11/20/2014)

---

eirikur, the query you provided is good. Not sure it performs faster in myenvironment tho. Once query execution plan is cached it's about same, but it is still better...

Quick thought, the character combination is double windows new-line, 0x0D000A000D000A00 in Unicode or 0x0D0A0D0A in ASCII, construct a variable with this value and use charindex to search for it.

😎

Charindex and...

Quick thought, IIF is kind of an oddity in this list as it brings nothing new but a Access SQL compatibility

😎

N_Muller (11/20/2014)

---

As far as I know there are two ways of reading XML using SQL, either openxml or XQuery. There's a lot of debate on which is better or...

Quick thought, this doesn't look right...

Multiple "Secure/SecureType" elements will multiply the outer/parent "SecureEvent" element, as this is...

Koen Verbeeck (11/20/2014)

---

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable me):

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note that you...

N_Muller (11/20/2014)

---

I have a table with an indexed XML column. Is it possible to use openxml that takes advantage of the indexes in the table? To my knowledge, openxml only...

Quick thought, if this type of queries are frequent, consider adding a geography column to the tables.

😎

Here is a far more efficient way of producing the same results

USE tempdb;

GO

SET NOCOUNT...

jasona.work (11/19/2014)

---

Well, this is shaping up to be an interesting winter here in North America...

Not even the end of November, and already we've got here in Detroit, Michigan, about 1/2"...