I'm having a problem with mssql. I accidentally inserted a value into a smalldatetime field using getdate(). When I try to delete the row using queries like
delete from tborders where nOrderID=1
delete from tborders where Convert(Varchar,dteOrderDate,103) = '22/03/2006'
It gives me the error;
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
Is there another delete statement I could use to get rid of this row?
Thanks in advance for your help.