How to search for value in sql 2000
Hi Experts i am trying to search for data in a sql 2000 data
using select * from table_name where Column_name = "Null";
but the command not work
Please help
using select * from table_name where Column_name = "Null";
but the command not work
Please help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nitin's solution didn't work for you?
ASKER
No data found however in the application result i can found some transaction without date
Please provide a screenshot with those cases.
Also let us know what is the data type for that column.
Also let us know what is the data type for that column.
ASKER
Sorry, I meant to provide a screenshot with the rows with the empty date.
And don't forget to let us know the data type of that column.
And don't forget to let us know the data type of that column.
ASKER
data type of the column smalldatetime
None of those rows have an empty date.
ASKER
i know
i am trying to search for these empty date from 7 am to 5pm with more than 100000 record so i need to use the command to search for this empty date record
i am trying to search for these empty date from 7 am to 5pm with more than 100000 record so i need to use the command to search for this empty date record
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think so
ASKER
thanks all @Nitin and @Vitor Montalvão
i search by Credit & Debit instead of date
and i found that record and delete it
i search by Credit & Debit instead of date
and i found that record and delete it
ASKER
i upload image from my server to describe my issue
i have some records on my application not shown date so i need to search for column date for the empty one