From BOL:

Columns defined with char, varchar, binary, and varbinary data types have a defined size.

This setting affects only the definition...

no - in any given clustered instance, one node is active and one or more nodes are inactive.

In the "active/active" setup, you would be looking to split your instance in...

Well my case was for a different reason, but I did manage to set the row and column delimiters to the same thing (which helped my scenario). Try \t...

Mark Fitzgerald-331224 (9/25/2012)

---

Which tool are you using to view the XML? As stated before the cr and lf should not be there, but also should not matter.

I have reproduced...

Understood on that, but as...

Grant Fritchey (9/25/2012)

---

SQL Kiwi (9/25/2012)

---

I tried my best, but...

Sigerson (9/25/2012)

---

"Better, faster, cheaper--pick two" is certainly a reality in our world and in any engineering discipline.

But we can do better, I think, in putting more emphasis on the DESIGN...

yuvipoy (9/25/2012)

---

Thanks for your replay,

As i have stated early [Quote]Inserting the data externally not from the database itself. [/Quote] my aim is not inserting from the database i need to...

karthikeyan-444867 (9/25/2012)

---

okay. why don't i use +2 or +3 instead of...

Deleting space completely is an entirely different exercise. Like Phil mentioned - that just takes one REPLACE to do that.

The numbers were chosen to avoid having to run the...

David F (9/21/2012)

---

So if I'm reading that correctly the answer is... "I dont know"... There is no defined rule for SQL to determine how to proceed, it very well could...

opc.three (9/21/2012)

---

tim_harkin (9/21/2012)

---

opc.three (9/19/2012)

---

Jeff Moden (9/18/2012)

---

And some folks wonder why I/O is one of the biggest bottle-necks on some servers. Imagine what it would cost to get a 300%...

Here's a version of FLWOR which approximates what you want (again - with the name isssue handled)

declare @x xml

;with a as (

select 'a123' partID, 'blue' color,'large' size

union all

select 'a124' partID,...

Assuming you fix your naming convention issue (yes - SQL Server will pick up on the invalid name issue), you can use a query like the one below (i fixed...

There's also the architecture route, which would depend on what kind of skills you leveraged as a DBA.