Hi am working with asp.net with backend Sql2000
i want to store NULL in datetime datatype field through coding. i wrote a update statement as
Update table set Date1='NULL' where ........
but while updating it is giving error converting varchar to datetime
how to store NULL in that field
please respond
Thanks in Advance
i want to store NULL in datetime datatype field through coding. i wrote a update statement as
Update table set Date1='NULL' where ........
but while updating it is giving error converting varchar to datetime
how to store NULL in that field
please respond
Thanks in Advance
Comment