My I insert a null value from VB6 or others into SQLServer2000 using Stored procedure?

Question

Hello All,
I have one condition that Is got Date value from field in VB6 programming then it will insert same date other wise if Date field is empty then a 'null' value should be insert into table.
The date field datatype is 'datetime'.

I have created a Stored Procedure and passing date value as follows.
StoreProcedure IIF(IsDate(text1.text),Text1.text,null)

It is giving error "Invalid us of null" and also giving error from SQL Query manage if I pass
StoredProcedure null


Please help me
thanks in advance

In the above not showing
"IIF(IsDate(text1.text), Text1.text,null)"

Answer 1

Try passing DBNull.value instead of NULL to the SQL server

Answer 2

http://www.c-sharpcorner.com/Code/2003/Sept/EnterNullValuesForDateTime.asp

But to be perfectly honest, why do you want null values for DateTime? Optimize your system and build a table that normalizes your need to use a datetime function.

Answer 3

you can check the option of "allow null" or "not null" in the column of the database and it will be ok.

Answer 4

surely, it somewhat is already Saturday. regardless of the undeniable fact that, truly, it somewhat is the day God stopped poofing. He poofed for 6 days, and on the seventh rested. So fairly of celebrating the poofing, we rejoice the resting. even yet it somewhat is nonetheless meant to remind us to think of relating to the six days he spent poofing.