title: Error in using XML data type
body: <pre><code>declare @x xml
  set @x = '&lt;Root&gt;
            &lt;row id="1"&gt;&lt;name&gt;Larry&lt;/name&gt;&lt;oflw&gt;some text&lt;/oflw&gt;&lt;/row&gt;
            &lt;row id = "2"&gt;&lt;name&gt;moe&lt;/name&gt;&lt;/row&gt;
            &lt;row id = "3"/&gt;
            &lt;/Root&gt;'
   select T.c.query(..) as result from @x.nodes('/Root/row') T(C)
  
  select T.c.query(..) as result from @x.nodes('/Root/row') T(C)
  </code></pre>
  
  <p>I am getting following error.</p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 1
  Incorrect syntax near ')'.
  </code></pre>
  
  <p>could any one help me correcting the error. I am new to sql .</p>