Share on Facebook

Monday, April 5, 2010

No row was updated Error in SQL Server 2008

No row was updated.
The data in row 1 was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: Cannot insert the value NULL into column 'ID', table 'TeamDB1.dbo.PlayerDetails'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Correct the errors and retry or press ESC to cancel the change(s).

This error occurs when you try leave a Primary Key Field empty

No comments:

Related Posts Plugin for WordPress, Blogger...