by Sheila Zhang

This is a continuation from a previous blog.
When creating documentation, you can use a reference in some types of tags. The compiler translates the reference for you. For example: 
 
It will convert the simple method name to the full method name:
...

by Derek Du
I use .NET XML serialization a lot and sometimes struggle with marking the nested classes with attributes to serialize correctly. How the serialization works seem to be tricky at first glance, although I can get it right with trial and error. That’s not optimal. I decided it’s time to make a summary of the tips and tricks I learned through the recent projects.
Serialize a C...

by Sheila Zhang

by Sheila Zhang
This blog is a continuation from my previous blog: How to Query Using Microsoft SQL Server to Create XML, found here. 

Another great query using Microsoft SQL Server to create XML is using this process:

You can manually define your selected SML format by using the PATH option of the FOR XML clause.  In the PATH mode, the standard XML XPath, which describes the path...

by Sheila Zhang
Using Microsoft’s SQL Server 2012 makes querying with XML a lot easier.  Microsoft’s SQL Server allows you to create XML with a SQL query or shred XML into a data table format.  I have shared with you below examples of achieving this query process faster.

When you use the "FOR XML" clause in the "SELECT- T_SQL" statement, you convert a query record set to XML...