Wednesday, March 7, 2012

Inserting Values to Identity column.

Hi all,

I have a Table Which only have one column, and that column is also an Identity column. Does anybody know how to insert values to this table. I know that if I change the table and add another column I can solve this problem. But because I can't change the of the Database design provided to me by my architect, I have to find a solution for this.

Please help me......

Regards,
Sandarenu

you could use the statement "SET IDENTITY_INSERT ON" before the insert statement.

you can read about the usage from books online

No comments:

Post a Comment