Parameters

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

I write to write a Query that can return all rows or a specific row by
passing a parameter.

parameter custparm integer;
select * from customers
where customerkey = custparm

Of course, if I want s specific customer, I pass his customerkey,
but what can I do, or what can I pass as custparm that will return ALL rows.

Thanks!
 
select * from customers
where customerkey = Nz([Enter Customer Key or Leave Blank for
all],CustomerKey)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing a List through a Parameter 7
Parameter Query help - Not passing parameter? 3
Using LINQ to SQL with multiple databases 1
ODBC Pass-through query with parameter from table 5
help using a parameter in an 'In (...)' criteria 3
problem inserting data through Entity framework's Addto() method. 0
Access Invalid bracketing of parameter name 1
Query Parameter using multiple options 0

Back
Top