Groups > comp.databases.ms-sqlserver > #101

Re: Bad Stored Procedure Code: Why?

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: Bad Stored Procedure Code: Why?
Date	2011-04-04 14:44 -0700
Organization	A noiseless patient Spider
Message-ID	<pqekp6hvllgnpbueboaeshj2sg77u3c4qs@4ax.com> (permalink)
References	<h9dkp659lbjlbd0l8u0fl6grn1g5v6n3h0@4ax.com>

Cross-posted to 2 groups.

Show all headers | View raw

On Mon, 04 Apr 2011 14:26:33 -0700, Gene Wirchenko <genew@ocis.net>
wrote:

[snip]

>execute NiceString @strBefore,@strAfter

[snip]

>     What am I missing, please?

     I found it myself.

     The call should be
execute NiceString @strBefore,@strAfter output

     This is the sort of thing that should get a warning or error
message.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Bad Stored Procedure Code: Why? Gene Wirchenko <genew@ocis.net> - 2011-04-04 14:26 -0700
  Re: Bad Stored Procedure Code: Why? Gene Wirchenko <genew@ocis.net> - 2011-04-04 14:44 -0700

csiph-web