\nOK, I couldn't help myself. The Dec 2004 CTP-specific readme had quite a number of things that are new. There are many improvements in SSIS, for example. The “real“ readme and the known issues file (sqlki.chm) still have July dates on them. But there are always a few little things I have queued up to try with a new build. Here's some that took 5 minutes after installing to test:\n<\/p>\n
\n1. "Smiley face" XQuery comments still don't work. {– comment –} still does.
\n2. INTERSECT and EXCEPT still not there. They are however, still in BOL.
\n3. FOR XML still does not work with UDTs. However, convert UDT to XML type DOES.\n<\/p>\n
\ncreate table ctab (cnum complexnumber)
\ninsert ctab values('1:1i')
\ninsert ctab values('2:2i')\n<\/p>\n
\n— works! 2 rows returned with nicely formatted XML in them
\nselect convert(xml, cnum) from ctab\n<\/p>\n
\n— fails, Msg 6865, FOR XML does not support CLR User Defined Types
\nselect * from cnum for xml auto\n<\/p>\n
\nI wonder why one works and not the other. Should use almost the same codepath for serializing UDT. Oh well. That's all for now. More later.<\/p>\n","protected":false},"excerpt":{"rendered":"
OK, I couldn't help myself. The Dec 2004 CTP-specific readme had quite a number of things that are new. There are many improvements in SSIS, for example. The “real“ readme and the known issues file (sqlki.chm) still have July dates on them. But there are always a few little things I have queued up to try with a […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,37,40],"tags":[],"class_list":["post-986","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005","category-sql-server-xml","category-transact-sql"],"yoast_head":"\n