am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ?
pls help me.
i am using this database with visual studio 2008
Software/Hardware used:
ASKED:
July 24, 2008 9:41 AM
UPDATED:
July 28, 2008 8:00 AM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
if you check the properties of column_id, it would not have been set as a primary key, else it would not allow null values.