Viewing 3 posts - 1 through 3 (of 3 total)
Sue,
Here is a simple example of a stored proc that searches on the parameters supplied.
Use nulls for the parameters that are not supplied.
USE pubs
GO
CREATE PROC SEARCH_AUTHORS
@lastName varchar(50),
...
April 11, 2002 at 10:18 am
#427056
Check the data. Does the result set make sense? Are there duplicates?
April 11, 2002 at 8:41 am
#427038
A user complains that they can't log on and you say "Try it now."
April 9, 2002 at 8:45 am
#426866