This site will work and look better in a browser that supports web standards, but it is accessible to any browser or Internet device.

CleanCode logo
sitemap
SEARCH:
NAVIGATION: first page in sectionprevious pagenext pagefinal page in section

SP_map

N U T S H E L L
ModuleSP_map
DescriptionSP_map a list or a matrix to an arbitrary DML statement
EnvironmentSQL Server 2000/2005
AuthorMichael Sorens
SinceCleanCode 0.9.17

Deprecated -- see Map.


Usage and Parameters

SP_map @StmtTemplate, @MainArray, @AuxArray, @Permute, @Accumulate, @AccumulateFilter, @Verbose, @Process

where:
   @StmtTemplate      ::= [DML statement]
   @MainArray         ::= "'" { [main item] "," } [main item] "'" | [select statement]
   @AuxArray          ::= "'" { [aux item]  "," } [aux item]  "'" | [select statement]
   @Permute           ::= "1" to perform all permutations, or "0" to match indices
   @Accumulate        ::= "1" for single result set; "0" for individual result sets
   @AccumulateFilter  ::= [filtering predicate]
   @Verbose           ::= "0"-"3" for no diagnostic output or progressively more
   @Process           ::= "1" to execute; "0" to only show generated statements
Get CleanCode at SourceForge.net. Fast, secure and Free Open Source software downloads
Copyright © 2001-2013 Michael Sorens • Contact usPrivacy Policy
Usage governed by Mozilla Public License 1.1 and CleanCode Courtesy License
CleanCode -- The Website for Clean DesignRevised 2013.06.30