Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #133
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming |
| Subject | Re: Stored Procedure Code Critique Requested |
| Date | 2011-04-06 23:58 +0200 |
| Organization | Erland Sommarskog |
| Message-ID | <Xns9EBFF3D85BA79Yazorman@127.0.0.1> (permalink) |
| References | <nk1np6tl9rthkh068vji35fpq34p7v21ff@4ax.com> <Xns9EBF62D99BA9FYazorman@127.0.0.1> <sqcpp6pio7klsauoodg3cn86om9tp3caah@4ax.com> |
Cross-posted to 2 groups.
Gene Wirchenko (genew@ocis.net) writes: > What I am going to put on top of this is an insert/update trigger > to clean up strings. Can I call .Net code from within a trigger? Yes. I think you would put this in a function, and calling CLR UDF is just the same as calling a T-SQL UDF. You can even write triggers directly in the CLR. I will have that I have yet to see a use case for that. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Stored Procedure Code Critique Requested Gene Wirchenko <genew@ocis.net> - 2011-04-05 14:26 -0700
Re: Stored Procedure Code Critique Requested Erland Sommarskog <esquel@sommarskog.se> - 2011-04-06 07:43 +0000
Re: Stored Procedure Code Critique Requested Gene Wirchenko <genew@ocis.net> - 2011-04-06 11:43 -0700
Re: Stored Procedure Code Critique Requested Erland Sommarskog <esquel@sommarskog.se> - 2011-04-06 23:58 +0200
Re: Stored Procedure Code Critique Requested Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-06 21:15 +0200
Re: Stored Procedure Code Critique Requested Gene Wirchenko <genew@ocis.net> - 2011-04-06 14:59 -0700
Re: Stored Procedure Code Critique Requested Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 00:05 +0200
Re: Stored Procedure Code Critique Requested Philipp Post <post.philipp@googlemail.com> - 2011-04-12 06:14 -0700
csiph-web