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

Re: Adding Multiple Rows via (?)Stored Procedure

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: Adding Multiple Rows via (?)Stored Procedure
Date	2011-04-01 23:37 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9EBAF0567124Yazorman@127.0.0.1> (permalink)
References	<2s0ap6l564deoh3kp46dh92brn1g3kr1m0@4ax.com> <c51b3355-b1b8-41a2-97df-57fb968326a4@d28g2000yqf.googlegroups.com>

Cross-posted to 2 groups.

Show all headers | View raw

--CELKO-- (jcelko212@earthlink.net) writes:
> You can use a long parameter list and do the math and validations in
> the same procedure. This will be portable code.
 
Most of all it will be completely unusable garbage, and SQL Server the 
performance penalty is severe. It's an awfully bad suggestion.



-- 
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 | Find similar | Unroll thread

Thread

Adding Multiple Rows via (?)Stored Procedure Gene Wirchenko <genew@ocis.net> - 2011-03-31 15:53 -0700
  Re: Adding Multiple Rows via (?)Stored Procedure Erland Sommarskog <esquel@sommarskog.se> - 2011-04-01 09:24 +0200
  Re: Adding Multiple Rows via (?)Stored Procedure --CELKO-- <jcelko212@earthlink.net> - 2011-04-01 07:09 -0700
    Re: Adding Multiple Rows via (?)Stored Procedure Erland Sommarskog <esquel@sommarskog.se> - 2011-04-01 23:37 +0200

csiph-web