Re: Doubt about using Parametrized query with IN

you can't do that - the ? is a single value parameter and cannot
specify a range of values which is expected with an IN clause.

the typical usage for parameters in SQL CE is:

SELECT * FROM Defects WHERE DefectCount = ?
or
UPDATE Defects SET DefectCount = ? WHERE ID = ?
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
news:1130422317.345764.211220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> My query in the case is:
>
> SELECT .... FROM table WHERE column1 IN (?)
>


.

Relevant Pages

  • Re: Using a Select Query to build a MDB table from a Fox table
    ... MS Access has a 'make-table' query with IN clause you can specify ... As you said the IN <database> clause is specific to Access SQL. ...
    (microsoft.public.fox.helpwanted)
  • Re: Order of records in table as a result of a Query
    ... A query will be displayed in the order specified. ... It is actually writing the records in the order you specify, ... Obviously the INSERT INTO is ignoring the ORDER BY clause. ... AL EXPORT in the same order as they exist in AL EXPORT SORT. ...
    (microsoft.public.access.queries)
  • Re: Create table and default order by clause
    ... by" clause to use when no "order by" clause is specified in a "select" query ... the only way to guarantee result order is to specify ORDER BY in the SELECT statement that selects from the table. ... Note that it is likely, but not guaranteed, that you will get results ordered in sequence by the table's clustered index in a trivial query with no joins or where clause. ...
    (comp.databases.ms-sqlserver)
  • Re: SQL92 JOINs
    ... So the following query will ... Whatever you specify in where clause is a filter on the resultset of above resultset. ...
    (microsoft.public.sqlserver.programming)
  • RE: Any good T-SQL quick reference recommended?
    ... The full syntax of the SELECT ... SELECT Clause ... Specifies the columns to be returned by the query. ... Specifies that duplicate rows can appear in the result set. ...
    (microsoft.public.sqlserver.programming)
Quantcast