sql server new users: I've got a table where one of the fields is "bit" .. and I need to set it so
that if no value is inserted with the new record, the value of that field
should be "0" (zero) .. but instead, the table shows <null> instead!!! This
is wreaking having with my ASP.. Entering in 0 by itself in the "Default"
value window of that field doesn't work.. it still creates nulls.. what do I
need to do so that the field enters 0 instead of null?

This is one method.


ALTER TABLE MyTable
ADD CONSTRAINT df_MyBitColumnDefault DEFAULT 0 FOR MyBitColumn

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Hi Arnie.. sorry, a relative newbie here.. I was thinking there was a way to
do it in enterprise manager...

You'll find most experienced folks avoid Enterprise Mangler -for lots of
good reasons.

However, I think that you can right-click on the table, select [Design
Table], and then select the column and add the default value at the bottom
where it indicates. Be warned, if this is a large table,this bass-ackward
method may take some time to complete.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Hi Arnie.. I tried the method you described, and the value I'm trying to set
is 0, but when the record is created, if no other variable is inserted in
the table, it shows up as NULL, not 0.. which ASP reads differently.

Umm.. and if I don't use Enterprise Mangler.. what should i be using? Please
pardon my ignorance...

Did you 'unselect' the [Allow NULLs] checkbox?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Thats an excellent question.. and I'll try it.. thanks .. its always the
simple things

[quoted text, click to view]

Hi adrian,

Could you describe HOW you enter a row in the table? I think that that
is where the problem lies.

[quoted text, click to view]

Query Analyzer.

--