Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bahiapt
Starting Member
6 Posts |
 Posted - 2013-05-28 : 09:54:45
|
| HI all,Got an issue when doing relationships betwen tables (ID's), see below:"sql cannot insert the value null into column"anyone got an idea of what is is?Best regards,Daniel |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-28 : 10:25:33
|
| This happens when you try to insert a NULL value into a "NON-NULLABLE" column. Each column in a table can be nullable or non-nullable. If it is declared as non-nullable, then you MUST provide a value that is not null for that column.If that doesn't help, post the insert statement, and the DDL for the table. If you need help generating DDL's, this page might help: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
|
|
|
Error message