Error description:

Cannot insert the value NULL into column ‘SourceId’, table ‘Advisory.dbo.AdvDocSource’; column does not allow nulls. INSERT fails.
The statement has been terminated. The ‘CompanyAdd’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
——————————-

This error occurs because the ‘SourceId’ column in my table is primary key and it is set to not null. i.e. it doesn’t allow null entries. And I have not made it auto increment.

For making a table column auto increment:
- Go to server explorer.
- In Column Properties, go to Identity Specification.
- Go to (Is Identity) and make it ‘Yes’ from the selection list.

You are done. You also have the option for Identity Increment and Identity Seed.

The SQL Query is:
CREATE TABLE [yourTableName](SourceID int IDENTITY(1,1) NOT NULL, …

Related posts:

1. Magento: How to select, insert, update, and delete data?
2. Very Useful SQL Queries with JOINS
3. Displaying all products and new products listing in column/grid layout – Zen-cart
4. ASP.NET Error: A potentially dangerous Request.Form value was detected from the client
5. ASP.NET Error : An HtmlSelect cannot have multiple items selected when Multiple is false.