what's wrong with query ?
INSERT INTO employee (id,name) values (2,'h') what's wrong with the query?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Jan 6, 2021, 11:13 AM
Vinitha TPosted Nov 24, 2021, 1:46 PM
Check with your Id column, whether it is IDENTITY column or not.
If it is Identity column, not in need to mention id value in insert query. Id column will get valued automatically.
Another way for insert query with IDENTITY column is you can mention it as DEFAULT.
Sachin SinghPosted Jan 6, 2021, 11:50 AM