Saturday, July 23, 2011

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

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Deep's | Bloggerized by Deep - Deep's Templates | ElearSQL-Server