Re: Stored procedure with unknown numer of paramters, how?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 29 Mar 2006 22:02:28 +0000 (UTC)
Igor (jerosimic@xxxxxxxxx) writes:
But that one works only with one categorie and i need to search for one
or more categories at once, does anyone have a solution? Is there
something like ellipsis (...) in C++ for MSSQL?
No. There are a couple of methods to pass lists of data to SQL Server. Tom
mention XML. For a single list, that may be a little heavy-handed. Check out
http://www.sommarskog.se/arrays-in-sql.html#iter-list-of-integers for
one alternative. Read the rest of the article to see some more.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prev by Date: Re: database design for fast client updates
- Next by Date: Re: Optimizing SQL - Union
- Previous by thread: Re: Stored procedure with unknown numer of paramters, how?
- Next by thread: Re: Stored procedure with unknown numer of paramters, how?
- Index(es):
Relevant Pages
|
