Andrea wrote:
> I need to create a stored proc that run a select with dynamic where clause.
> For example:
>
> SELECT * FROM Table WHERE country=1
> SELECT * FROM Table WHERE name='james'
> SELECT * FROM Table WHERE country=1 AND name='james'
> SELECT * FROM Table WHERE city='NewYork'
> SELECT * FROM Table WHERE name='james' AND city='NewYork'
> SELECT * FROM Table WHERE name='james' AND city='NewYork' AND country=1
> SELECT * FROM Table WHERE city='NewYork' AND country=1
>
> I'd like to pass the where clause to the stored procedure from my code.
> If I execute the query from the code I can create a string with the select
> than execute the string, but I can't find any solution to use a stored proc.
>
> I tried to create a parameter
>
> @QueryClause as varchar
>
> and use it like this
>
> SELECT * FROM Table WHERE @QueryClause
>
> but doesn't works, because the parameter is seen like a value.
>
> How can I solve this problem.
>
> Thanks for your help.
>
> Andrea
>
>