add a column,in existing table ,type bit,but should take defult value 0 not null,(Want Query)

Question

1.00/5 (1 vote)

See more:

ALTER TABLE OrderTypeMaster ADD PckDtlReqd bit DEFAULT (0)

i m using it but it takes default value null

plz help

Posted 28-Dec-12 0:51am

StackQ

Add a Solution

4 solutions

Solution 2

SQL

ALTER TABLE OrderTypeMaster
ADD PckDtlReqd BIT
GO

ALTER TABLE OrderTypeMaster
            ADD CONSTRAINT DF_OrderTypeMaster_PckDtlReqd
            DEFAULT 0 FOR PckDtlReqd

Regards ,
Vijay

Posted 28-Dec-12 0:57am

P.S Vijay

Solution 3

ALTER TABLE OrderTypeMaster ADD PckDtlReqd bit DEFAULT (0) NOT NULL

Posted 28-Dec-12 0:58am

kankeyan

Solution 4

Alter table OrdertypeMaster add PckDtlReqd bit default(0) with values

Posted 28-Dec-12 1:17am

StackQ

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 · Accepted Answer · 2012-12-28T00:56:00

Solution 1

Try:

SQL

ALTER TABLE OrderTypeMaster ADD PckDtlReqd bit DEFAULT (0) NOT NULL

Posted 28-Dec-12 0:56am

OriginalGriff

Comments

StackQ 28-Dec-12 7:19am

it's also working right,but it change column constraint to not null,which is not right according to my requirement.But thnx for help.+5

OriginalGriff 28-Dec-12 7:29am

Unless you specify NOT NULL, the default value is ignored - it will always insert a null instead of the default when you do not specific a value for this column, unless you specify WITH VALUES in which case the default value will be used for all existing rows in the table (but still not for new ones). Specifying NOT NULL is to only way to persuade SQL to use the default value instead of a null when you INSERT a new row.

StackQ 29-Dec-12 4:33am

YA,i agree with u.So as u explained,this is new for me,it explore me better,Thnx

OriginalGriff 29-Dec-12 4:46am

You're welcome!

StackQ 29-Dec-12 4:51am

thnx, u always help me,and push me to go ahead.thnx for ur support.

Now i have a new question,take a look at it:-

http://www.codeproject.com/Questions/517850/Logicplusbehindplusguidplusinplusc-23pluswindows-3