Saving data in table in SQL Server 2005

Question

I am asp.net developer and I work with SQL Server 2005 .

I have a table with 4 columns

say

Name
RollNo
Std
Div

if client enters

Name
RollNo
Std

but doesn't enters 4.Div column data and try's to save data, it should not give error, it should save the data in database

if yes what will be the problem ? and if not then what will be the problem ? can u kindly explain ?? — C J
– C J, Commented Dec 5, 2010 at 3:02
@user404305, if you have the column set for non-nullable it will be expecting a value, if you don't provide one, your user will get an error screen and the insert won't go through. If the column allows nulls then the insert will go through fine with no data for the column. — The Muffin Man
– The Muffin Man, Commented Dec 5, 2010 at 3:04

The Muffin Man · Accepted Answer · 2010-12-05 03:00:57Z

1

So it is giving you an error? Make sure that you set 4. Div column to "Allow Nulls"(No value).

It's also good to know that SQL Server can be set up to insert a default value if one isn't provided.

answered Dec 5, 2010 at 3:00

The Muffin Man

20k30 gold badges128 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Manish Pansiniya · Accepted Answer · 2010-12-05 05:42:25Z

0

HI,

That means that you need to save with either default division for standard or null value.

You can setup in database to allow null and do not pass anything and that saves the data with null values.

Otherwise, I think you should put default value in Div for that standard. So whenever you dont pass that value in Insert statement, it takes default one.

Will it help or do I misunderstood it?

answered Dec 5, 2010 at 5:42

Manish Pansiniya

5451 gold badge4 silver badges15 bronze badges

Comments

Eaglebird · Accepted Answer · 2010-12-05 03:03:39Z

0

If I understand your problem, you're going to have NULL in one of your fields (provided you allow nulls in the fields). Depending on where you're experiencing your problem, your code would need to test for NULL from the information a client inputs or your code will need to test for NULL when it retrieves the information.

If you're running into an error, it might be prudent to post details of the error as well.

answered Dec 5, 2010 at 3:03

Eaglebird

5323 silver badges5 bronze badges

Collectives™ on Stack Overflow

Saving data in table in SQL Server 2005

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related