April 29, 2009 at 11:37 pm
I had created a table with primary key named 'qId'.
when it was created the identity was 'no' (false).
because of that i am unable to insert any data through sql statement.
Without changing any manually structure i want to change identity 'yes'
and increment by (1 ,1)
Please help me.
April 30, 2009 at 12:22 am
gaurav (4/29/2009)
I had created a table with primary key named 'qId'.when it was created the identity was 'no' (false).
because of that i am unable to insert any data through sql statement.
Why...?.
April 30, 2009 at 1:06 am
1. You SHOULD be able to insert data with or without Identity column.
Can you post the Insert statement?
2. To change the NON-Identity column to Identity column, go to the table designer and change the Identity property from column properties to 'Yes'
April 30, 2009 at 6:39 am
...And once you make a column as identity, no need to supply any value for that column while inserting.....
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply