stored proc input parameter
i have a generic stored procedure where i pass one input parameter.
something like select a, b, c where a = @id
i use this stored procedure in several places in my asp page.
in one instance i want @id to be = all the ids meaning i want to ignore the where clause . i tried to pass a wildcard char % to @id but that doesnt seem to work. any ideas??
|