I have read about "What is in your CLR" just now and noticed the below questions.
The above Q&A is part of a teaser for the PASS conference but it does bring up a couple of questions of my own...
1. What's in YOUR CLR? In other words, what have you written a CLR for? What did it do? If you don't use CLR's, why not?
2. If you have written CLR's, why did you write them (or it)? Was it because you didn't know how to do item 1 above in T-SQL, it couldn't be done in T-SQL, or because it was more performant as a CLR or something else?
3. Looking back at it, was it an appropriate thing to do?
4. Even if you haven't written a CLR, what would you consider a CLR to be appropriate for? Please be a bit specific if you can and if you have the time. Saying something like "math intensive tasks" or "string manipulation" tasks is what most people say but there's a lot of those things that can easily be done in T-SQL.
For this Friday poll, what would you consider a task that should done in a CLR instead of T-SQL and why?
EE,
Can you clarify some of the questions ? since you used CLR to resolve this problem, I am just asking this question.
To answer this question
If you don't use CLR's, why not?
Poor knowledge on CLR.
No idea about when to use / not to use.
How to get rid out of this? Read abour CLR on BOL. This could be answer from the expeerts. Apart from that
it couldn't be done in T-SQL
...If so, why should i learn CLR?
The real question is
No idea about when to use / not to use
For a give problem, Again No idea which one should be used i.e T-SQL or CLR. On what basis this decision/estimation will be taken?
karthik