Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2008-06-06 : 02:34:20
|
Hello,
I have just migrated some databases from sql2000 to sql2005
and I just read about the possibility to use CLR-based functions within a query.
This may be really nice for me, since I often need complex functions and I often cannot write them in TSQL.
But my question is: what kind of data can I pass in a sql query to a .net function?
Obviously, simple data, like numbers and strings from within a record can be passed.
But would it be possible to go further, like passing a complete record, or even passing a set of records?
How far could I go in sql when using .net function?
Thanks to inform me about the available power of this new feature.
|
|
|
|
|
|
in a query, passing data to a .net function