Inserting a NULL or 0 value for the existing records

Question

0.00/5 (No votes)

See more:

I need to create a field for deleted records in SQL but as the field is newly implemented what should be the state for already exisitng records? As the column is a boolean field.

What I have tried:

Created a column in DB as a boolean field,but for the existing fileds does the value should be null or 0?

Posted 1-Jul-21 20:57pm

chandra sekhar

Updated 1-Jul-21 21:47pm

Add a Solution

Comments

PIEBALDconsult 2-Jul-21 9:44am

Rather than a boolean value, consider a datetime which is NULL for current records and the timestamp of deletion for deleted records, it's a much more informative.

Maciej Los 5-Jul-21 4:19am

This sounds like an answer!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-07-01T21:47:00

Solution 1

When you create the field, you can set a DEFAULT value: SQL DEFAULT Constraint[^]

But, for a boolean field what value it should have is use specific: for a BIT field 0 is false and 1 is true - but your application will determine which way existing records should be set. If it's a "deleted" indicator, then if all existing / new rows should be considered "undeleted" then you'll want false for example.
We dont; know how you plan to use this, so we can't tell you "do this"!

Posted 1-Jul-21 21:47pm

OriginalGriff

Comments

chandra sekhar 2-Jul-21 5:35am

Correct, but what is the best option to insert for already existing records? I have a driver table where i am inserting the deleted column with (bit,null) but for the existing drivers what should be the correct way to show the value a null or 0 and in which scenario null is inserted?

OriginalGriff 2-Jul-21 6:00am

How would I know which you need: 0 or 1?
Read what I said, please!