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 |
|
cruxmagi
Starting Member
38 Posts |
 Posted - 2008-04-26 : 05:04:04
|
| does any one help me out to know the CLR stored procedures in SS2005I need to work with CLR sp's in .net framework 2.0 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-26 : 05:18:59
|
| http://www.dotnetfun.com/articles/sql/sql2005/SQL2005CLRSProc.aspx |
 |
|
|
cruxmagi
Starting Member
38 Posts |
Posted - 2008-05-06 : 01:16:43
|
| visakh16I should give ppt presentation on this topic.Can u suggest me a link where i can have topics like1)Adv of clr proc2)Dis Adv and so on |
|
|
|
cruxmagi
Starting Member
38 Posts |
Posted - 2008-05-09 : 08:31:02
|
| This url is useful to prepare ppt abt SQLCLR stored procedures and functions etchttp://searchsqlserver.techtarget.com/loginMembersOnly/1,289498,sid87_gci1135090,00.html?NextURL=http%3A//searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0%2C289625%2Csid87_gci1135090%2C00.html |
|
|
|
eralper
Yak Posting Veteran
66 Posts |
Posted - 2008-05-09 : 09:24:34
|
| Advantages are adding your business logic into SQL Server.For example I was using SQL Server Reporting Services scheduled subscriptions for sending emails which include reports.Later than I had to add this logic behind a trigger or a queue and move all the code into sql. Of course CLR helped me much in this situation.Of course calling a web service from a CLR is adding some more difficulty :)CLR enables a developer to add new custom data types and complex validation rules on data.Since t-sql is more powerful for fetching bulk data from database, to process each row or each column value one by one CLR can be helpful instead of using cursors.You can also keep your business logic within your data. But this should be well balanced. Since database is not a place to hold logic eventually. It's main purpose is keeping data.Eralperhttp://www.kodyaz.com/content/SQLServerArticles.aspx-------------Eralperhttp://www.kodyaz.com |
|
|
|
|
|
|
CLR Stored Procedures