Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Null values passed to SQL stored procedures.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-25 : 08:48:00
Jim writes "Is it possible to pass null values or empty strings as arguments to SQL stored procedures? I would like to check the data in the stored procedure before the procedure does an insert operation.
However the procedure crashes as soon as it is called from ADO. I have been able to fix the problem by substituting a space character for a null before ADO Executes the stored procedure."
   

- Advertisement -