|
|
Posted by billmiami2 on 05/27/06 20:27
Erland,
Thanks for the reply. I certainly see how rewriting the extended
stored procedures would be beneficial and would almost be a slam dunk
in favor of the CLR. I did one just for fun that calls a web service,
passes parameters and displays the resulting dataset as a resultset.
This is probably not something that I would do in an production
environment, but it certainly opened my mind to the possibilities.
I'm aware that the assemblies are stored in SQL Server upon running
CREATE ASSEMBLY so there is no direct dependency. However,the
assemblies must initially be made accessible to the SQL Server so that
it can bind to them. Also, if an assembly is changed, the revised file
must be again made available, so you're still having to manage files
that you wouldn't need to manage had you used T-SQL only.
Can you foresee using some of the new T-SQL enhancements in your
product? I have a couple of projects that involve hierarchies and the
recursive Common Table Expressions and Cross/Outer Apply have made for
far simpler queries than I could have created in SQL 2000. I haven't
used them in production yet, but the ranking functions look very nice
too.
Bill
Navigation:
[Reply to this message]
|