how to replace data when insert into database?
for example i am using bit datatype in table design...but when i insert record i want to replace (Yes/No) to (True/False)?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Iftikar HussainPosted Jul 27, 2013, 7:15 AM
While inserting the record pass '1' for 'Yes' and '0' for 'No'. Since it is a bit datatype it will take only either 1-True or 0-False.
Regards,
Iftikar
Sunny SharmaPosted Jul 27, 2013, 7:00 AM
Basically that doesn't make any sense what you're asking because a Yes/No is a synonym for True/False. What Say?