General information
Category:
Database DAO/RDO/ODBC/ADO
Hey folks, I have found an answer to my question. If a parameter is null, just don't pass it ! All you have to do, is to put a default value in the parameter of your stored procedure. Before calling you procedure and putting the variable value in the parameter collection, just check the value and if it's wrong, then ton put any argument in your parameter !!!
Ex:
sp_Example
@ExampleID int, @Name varchar(25), @LastName varchar(25) = NULL
as
Select...
Eric Trembaly
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only