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 |
|
isjord
Starting Member
38 Posts |
 Posted - 2006-01-09 : 19:25:49
|
| I was doing a database for the first time using the query analyzer this is my results.USE Registration GO INSERT INTO Student(studentID, studentName) VALUES(38214, 'Letersky') INSERT INTO Student(studentID, studentName) VALUES(54907, 'Altvater') INSERT INTO Student(studentID, studentName) VALUES(66324, 'Aiken') INSERT INTO Student(studentID, studentName) VALUES(70542, 'Marra') I got this as a result, I do not know what to change to make this work.Cannot insert explicit value for identity column in table 'Student' when IDENTITY_INSERT is set to OFF.How do I change this what does the error mean.Thanksalbanie |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Help with query