Friday, March 30, 2012

Problem in Insert in Table

Dear Friends
I have a table Which is giving problem for the Insert.
Insert ERROR:
Column Name or number of supplied values does not match table Definations
The same table is in replication. I have updated our Servicepack to 4 in
last w.
Please suggest how i can solve the problem.
Thanks and best regards
ShaileshYou have given less number of columns but included values for all the
columns
Post the query you used
Madhivanan|||hi sailesh
there might be difference between the columns and values passed in the
insert query..
eg:
INSERT INTO <TABLE>(ID, Name) VALUES (1, 'Chandra', 28)
please post the query so that we can give a better solution
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***

No comments:

Post a Comment