[dba-VB] Parameter objects in C# and ADO.

jwcolby jwcolby at colbyconsulting.com
Thu Nov 26 10:04:07 CST 2009


Thanks Stuart.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> SP with a parameter that is both Input and Output
> 
> In some situations, there is no need to store the output into an extra variable because the 
> output must replace the input.
> 
> CREATE PROCEDURE cap2 (@name NVARCHAR(20) OUT )
> --Capitalizes first char, changes the rest to lower case
> --SP with one input/output parameter
> AS
> SET @name=UPPER(LEFT(@name,1))+LOWER(RIGHT(@name,LEN(@name)-1))
> 
> or for you .net types, see
> http://fabioscagliola.spaces.live.com/blog/cns!919F8FCDE3DC9AC4!121.entry
> 



More information about the dba-VB mailing list