Dates, command parameters and SQL Server

Hi

I am having trouble firing a stored procedure that has a date parameter
using ADO command etc. Sometimes the date may not be completed so I want to
pass null back but it won't let me. Although the column type is dateTime the
parameter is nVarchar (SP was generated by a wizard as a test), but even if
I pass a zero length string it still inserts a date.

Do I need to place an IF statement in the SP or is there something I Can
pass from the command parameter that will get recognised as null?

Thanks inn advance

Mark


.

Relevant Pages

  • Re: Return value in stored procedure
    ... In Delphi (you can use TADOStoredProc, TADOQuery, but I would use ... (selecting the stored procedure of choice) ... select the Parameters property and verify Delphi 'filled in' ... begin {Start of with ADO command do} ...
    (borland.public.delphi.database.ado)
  • RE: [MSSQL2000] Stored procedures behaving weird?
    ... as recordset and not output param. ... > Now, since the stored procedure returns data trough OUTPUT parametar, I ... > doesn't return ANY data using OUTPUT parametars), I need to use ADO Command? ...
    (microsoft.public.sqlserver.programming)
  • RE: [MSSQL2000] Stored procedures behaving weird?
    ... as recordset and not output param. ... > Now, since the stored procedure returns data trough OUTPUT parametar, I ... > doesn't return ANY data using OUTPUT parametars), I need to use ADO Command? ...
    (microsoft.public.vb.database)
  • Re: Dates, command parameters and SQL Server
    ... > I am having trouble firing a stored procedure that has a date parameter ... > using ADO command etc. ... To pass null in a varchar/nvarchar parameter, you must set the Size property ...
    (microsoft.public.data.ado)
  • HELP !! Running SQL 2000 using ADO command object from Access 2000
    ... I'm running a SQL 2000 stored procedure from Access client using ... SQLOLEDB provider and ADO Command object. ...
    (microsoft.public.access.adp.sqlserver)