August 2011 we ran a contest where every
day we give away one book for an entire month.
The contest had extreme success. Lots
of people participated and lots
of give away. I have received lots
of questions if we are doing something similar this month. Absolutely, instead
of running a contest a month long we are doing something more interesting. We are giving away USD 198 worth gift every
day for this week. We are giving away Joes 2 Pros 5 Volumes (BOOK) SQL 2008 Development Certification Training Kit every
day. One copy in India and One in USA. Total 2
of the giveaway (worth USD 198). All
the gifts are sponsored from
the Koenig Training Solution and Joes 2 Pros.
The books are available here Amazon | Flipkart | Indiaplaza
How to Win:
Read
the Question
Read
the Hints
Answer
the Quiz in Contact Form in following format
Question
Answer
Name
of the country (The contest is open for USA and India residents only)
2 Winners will be randomly selected announced on August 20th.
Question
of the Day:
Is following XML a well formed XML Document?
<?xml version=”1.0″?>
<address>
<firstname>Pinal</firstname>
<lastname>Dave</lastname>
<title>Founder</title>
<company>SQLAuthority.com</company>
</address>
a) Yes
b) No
c) I do not know
Query Hints:
BIG HINT POST
A common observation by people seeing an XML file for
the first time is that it looks like just a bunch
of data inside a text file. XML files are text-based documents, which makes them easy to read. All
of the data is literally spelled out in
the document and relies on a just a few characters (<, >, =) to convey relationships and structure
of the data. XML files can be used by any commonly available text editor, like Notepad.
Much like a book’s Table
of Contents, your first glance at well-formed XML will tell you
the subject matter
of the data and its general structure. Hints appearing within
the data help you to quickly identify
the main theme (similar to book’s subject), its headers (similar to chapter titles or sections
of a book), data elements (similar to a book’s characters or chief topics), and so forth. We’ll learn to recognize and use
the structural “hints,” which are XML’s markup components (e.g., XML tags, root elements).
The XML Raw and Auto modes are great for displaying data as all attributes or all elements – but not both at once. If you want your XML stream to have some
of its data shown in attributes and some shown as elements, then you can use
the XML Path mode. If you are using an XML Path stream, then by default all values will be shown as elements. However, it is possible to pick one or more elements to be shown with an attribute(s) as well.
Additional Hints:
I have previously discussed various concepts from SQL Server Joes 2 Pros Volume 5.
SQL Joes 2 Pros Development Series – OpenXML Options
SQL Joes 2 Pros Development Series – Preparing XML in Memory
SQL Joes 2 Pros Development Series – Shredding XML
SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode
SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode
SQL Joes 2 Pros Development Series – What is XML?
SQL Joes 2 Pros Development Series – What is XML? – 2
Next Step:
Answer
the Quiz in Contact Form in following format
Question -
Answer
Name
of the country (The contest is open for USA and India)
Bonus Winner
Leave a comment with your favorite article from
the “additional hints” section and you may be eligible for surprise gift. There is no country restriction for this Bonus Contest. Do mention why you liked it any particular blog post and I will announce
the winner
of the same along with
the main contest.
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: Joes 2 Pros, PostADay, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology
