| Thread | Last Post | Replies |
|
| multiple-input user defined aggregates | 30 Oct 2008 02:53 GMT | 3 |
Where can I find a tutorial/samples of "multiple-input user defined aggregates"?
|
| aggregate+orderby=error | 30 Oct 2008 00:04 GMT | 5 |
I want to concatenate values to a comma separated list with CLR-function. And I want them ordered: select Table1.col1, (
|
| TRUSTWORTHY bit randomly being switched off | 24 Oct 2008 21:14 GMT | 4 |
we run a distributed system involving many database servers. On each server, we have a database called Meta which has no tables, only some helper functions and procs that other procs in other databases call. In this Meta database, there is an UNSAFE CLR assembly which some of ...
|
| CLR Function Definitions | 15 Oct 2008 18:55 GMT | 1 |
I'm having a time trying to figure out how to get the definition of a CLR function. In old days we could use SP_HELPTEXT. Now we have the OBJECT_DEFINTION function and SYS.SQL_MODULES table. However, when I try to get the definition of a CLR function I get NULL for any of these. ...
|
| dynamic columns in CLR table-valued-function | 09 Oct 2008 20:34 GMT | 1 |
I think this question was discused quite often before. But maybe some "good-brain" has a great idea ... :-))) I have a DataSet with "unknown" columns. The CLR Function should work like the normal TVF:
|
| unable to run "TextReader.ReadToEnd()" | 07 Oct 2008 19:23 GMT | 3 |
I have a .NET Assembly (Framework 2.0) with a SqlProcedure. In this SqlProcedure, one of the things is I create a TextReader like: System.IO.TextReader local_TR = new
|
| Substitute for SqlBulkCopy in SQL CRL | 02 Oct 2008 11:22 GMT | 3 |
After doing a big part of my work I have found that the "context connection" can't be used with the class SqlBulkCopy in SQL CLR. I was trying to insert in database using SqlBulkcopy and now I'm trying to find out the way to do these insertions having similar levels of ...
|