明天下班去南站买票，有需要带票的请吱一声。

Fix two bugs today. One is caused by the character "&", the other is caused by "&" too.

1. Cause: for xml clause in SQL Server 2005(Yukon) will encode the result as xml type.

   Code snip:

   declare @test as nvarchar(max)

   set @test = (select 'a & b' for xml path(''))

   select @test for xml path('')

   The string"a&b" if first encoded to "a & b", then "a &b". As a result, the character "&" is render as "&" on the web page

2. Cause: The query () method of xml data type returns an instance of untyped XML, whereas the value () methods returns as scalar value.

   Code Snip:

   declare @test xml

   set @test =convert(xml,N'<book> <title >Harry &amp; Potter</title> <author>J K. Rowling</author> </book>')

   select @test.query('book/title/text()') --(query reslut: Harry &amp; Potter)

   To fix it:

     select @test.value('(book/title)[1]','nvarchar(200)') --(query result : Harry & Potter)