Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #133
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming |
| Subject | Re: Stored Procedure Code Critique Requested |
| Date | Wed, 06 Apr 2011 23:58:15 +0200 |
| Organization | Erland Sommarskog |
| Lines | 17 |
| Message-ID | <Xns9EBFF3D85BA79Yazorman@127.0.0.1> (permalink) |
| References | <nk1np6tl9rthkh068vji35fpq34p7v21ff@4ax.com> <Xns9EBF62D99BA9FYazorman@127.0.0.1> <sqcpp6pio7klsauoodg3cn86om9tp3caah@4ax.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx01.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="13681"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19N4T1HOa7Vd6V0GJ1LwhSH" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:YJfVfpX/hnUg0R8fOuanrG/Evcg= |
| Xref | x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:133 |
Cross-posted to 2 groups.
Show key headers only | View raw
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