Friday, December 03, 2004

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 new build. Here's some that took 5 minutes after installing to test:

1. "Smiley face" XQuery comments still don't work. {-- comment --} still does.
2. INTERSECT and EXCEPT still not there. They are however, still in BOL.
3. FOR XML still does not work with UDTs. However, convert UDT to XML type DOES.

create table ctab (cnum complexnumber)
insert ctab values('1:1i')
insert ctab values('2:2i')

-- works! 2 rows returned with nicely formatted XML in them
select convert(xml, cnum) from ctab

-- fails, Msg 6865, FOR XML does not support CLR User Defined Types
select * from cnum for xml auto

I 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.

Friday, December 03, 2004 11:12:25 AM (Pacific Standard Time, UTC-08:00)  #    Comments [3]  |  Tracked by:
"bookmakers" (bookmakers) [Trackback]
"slot machine game" (slot machine game) [Trackback]
"slot machine" (slot machine) [Trackback]
"michigan hotels" (michigan hotels) [Trackback]
"Phentermine adipex." (Phentermine.) [Trackback]
"Generic ambien." (Ambien.) [Trackback]

Tuesday, December 07, 2004 1:33:27 PM (Pacific Standard Time, UTC-08:00)
What about Intellisense in TSQL Editing? Is it going to be included in the final release or is it gone for good?
Krishna
Tuesday, December 07, 2004 7:50:42 PM (Pacific Standard Time, UTC-08:00)
Gone for good in the SQL Server 2005 release, AFAIK.
Thursday, December 16, 2004 8:09:00 PM (Pacific Standard Time, UTC-08:00)
A quick note on the FOR XML and CLR UDT issue. This is currently not making it for SQL Server 2005. Since you can explicitly cast in the selection, you still can get the UDT back as XML in a FOR XML expression.
Comments are closed.

Theme design by Jelle Druyts

Pick a theme: