I have one XML

<Root>

<Student>Jhon </Student>

<Student> Luka </Student>

<Post>1</Post>

<Post>2</Post>

</Root>

Is it possible to add root node called Students for Student section and Posts for Post, as given below?

<Root>

<Students>

<Student>Jhon </Student>

<Student> Luka </Student>

</Students>

<Posts>

<Post>1</Post>

<Post>2</Post>

</Posts>

</Root>'

Hi,

I think we should not generalize; it is purely on case to case basis, if entity poses ordered attribute and that attribute make sense to the underline domain then...

Can you confirm table name, make sure there is no special character (blank space or tab) exists at the end of “Tabledivcomer”.

If blank space exists at the end of “Tabledivcomer”(...

For find out DB file size u can use this script

SET NOCOUNT ON

DECLARE @DBName VarChar(100)

CREATE TABLE #FileList

(

DBName VarChar(100),

FileName VarChar(500),

FileSize BigInt

)

DECLARE curDB CURSOR

FORSELECT Name FROM sys.databases

OPEN curDB

FETCH...