It won't either, i had run what WayneS is suggesting but it still doesn't work.

Mark-101232 (5/6/2011)

---

Haryadi Santoso (5/6/2011)

---

Hi Mark,

As i stated before, i had used ELEMENTS XSINIL, to product XML...

Hi Mark,

As i stated before, i had used ELEMENTS XSINIL, to product XML tag like <kotaDomisili xsi:nil="true" />

but the system still won't accept it. The system will accept XML tag...

Hi Wayne,

I try ur suggestion but the result is like this:

<row>

<clubId>0002</clubId>

<clubName>SUZUKI CLUB</clubName>

<tglBerdiri>2002-10-05 00:00:00</tglBerdiri>

...

Hi Nizam,

I think it depends on what you need exactly,

if u need to clear all rows in the table using "delete" syntax,

but if u need to delete the table also...

Hi Nizam,

I think it depends on what you need exactly,

if u need to clear all rows in the table using "delete" syntax,

but if u need to delete the table also...

Hi Nizam,

I think it depends on what you need exactly,

if u need to clear all rows in the table using "delete" syntax,

but if u need to delete the table also...

Dear Jo,

Why tempdb is faster to become full when i run such query in the table which has an identity column (Car_Service_Ordered)?

Why it doesn't happen in the same table (Car_Service)?...

fyi, i have shrunk and truncated the log file for tempdb database...but the problem still can't be solved...and the server harddisk still has 45 GB free capacity...

Hi Sergiy,

Yes, i'm sure. I have partitioned the server hard disk into three partitions C, D and E

Hi John, I did that you've suggested, my SQL Server machine run from the option: "system account" not the option "this account". What is that mean?

I always login to the...

dear Norene,

how and where to find out what is the account that runs the SQL Server??

fyi, i'm using an administrator login when installing the sql server initially.

Hi Lynn,

sorry, I forgot to copy the syntax for the UDFs

by the way, I've tried your SQL code and it works fine ...it took less time to run...

Hi Lynn,

sorry, I forgot to copy the syntax for the UDFs

by the way, I've tried your SQL code and it works fine ...it took less time to run...

Hi Lynn,

sorry, I forgot to copy the syntax for the UDFs

by the way, I've tried your SQL code and it works fine ...it took less time to run...

Hi Lynn,

sorry, I forgot to copy the syntax for the UDFs

by the way, I've tried your SQL code and it works fine ...it took less time to run...