C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » SQL Server »

Default value


Posted Date: 02 Nov 2009      Posted By: Uthaman      Member Level: Bronze     Points: 1   Responses: 4



hi

I declared a variable in sql server : Zipcode int. which doesn't allow nulls.
My problem is In zipcode field,defaultly the valu 0 is there.I'm not seting any default value. I want defaulty blank field.

Please clarify.
Uthaman.V



Responses
Author: Anil Kumar Pandey    02 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

hi,

either there be 0 or NULL you can set NULL as a default value..

Thanks & Regards
Anil Kumar Pandey



Author: satya    02 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

Set allow nulls true to that field...


Author: ABitSmart    02 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

What do you think setting a column as 'not null' means? You are having contradictory requirement. You say it cannot be null. Then you say you don't want any value also. Rethink your requirement.


Author: atulpatel    03 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

Please tell us your requirement in brief


Thanks,
Atul


Post Reply
You must Sign In to post a response.
Next : Query Optimize
Previous : How to display one column in different ways
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use