\nOK, SQLCLR wish list comes last. Mostly because I'm tired of being accused of being a SQLCLR bigot; I think it was because our book covered those topics first. Oh well.\n<\/p>\n
\nDefault parameter values in SQLCLR procedures when called by T-SQL. You obviously can't\/shouldn't support these when called from-CLR-to-CLR. Right now, they work, but the metadata doesn't recognize them. Nor does the SMO scripter.\n<\/p>\n
\nBetter exception\/error handling in SQLCLR when called by T-SQL. See this blog for my 6522-saga of entries.\n<\/p>\n
\n.NET 2.0 nullable type support for parameters. People always ask.\n<\/p>\n
\nOverloaded methods support. As an alternative, let me define each overload with different T-SQL names. Or just define one of them.\n<\/p>\n
\nBetter integration with System.Transactions for transaction nesting.\n<\/p>\n
\nBring back SqlExecutionContext and SqlDefinition.\n<\/p>\n
\nUDTs and UDAggs of greater than 8000 characters. This is a big one.\n<\/p>\n
\nSupport of IComparible (maybe in UNSAFE mode, I know why its off currently), operator overloads, inheritence, and multiple sort orders for UDTs.\n<\/p>\n
\nMore framework BCLs that comply with the "SAFE spec".\n<\/p>\n
\nUDAggs with more than one parameter, and that support .NET generics. The more than one parameter is more important of the two.\n<\/p>\n
\nEither support UDAggs' IsInvariantToOrder=false or remove the property from the attribute.\n<\/p>\n
\nSSMS should display a NULL UDT value like SQLCMD does.\n<\/p>\n
\nThat's all the wishes for now. Likely some that I left out. Cheers.<\/p>\n","protected":false},"excerpt":{"rendered":"
OK, SQLCLR wish list comes last. Mostly because I'm tired of being accused of being a SQLCLR bigot; I think it was because our book covered those topics first. Oh well. Default parameter values in SQLCLR procedures when called by T-SQL. You obviously can't\/shouldn't support these when called from-CLR-to-CLR. Right now, they work, but the […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,38],"tags":[],"class_list":["post-899","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005","category-sqlclr"],"yoast_head":"\n