var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how do i use the identity
i set the identity at the column to yes. i thought its suppose to auto generate number, by when i try to add some data into the table this error message appear
Cannot insert explicit value for identity column in table 'LoanItem' when IDENTITY_INSERT is set to OFF.
i did not add any value into the column that auto generate number
To force value, the IDENTITY_INSERT needs to be set ON:
SET IDENTITY_INSERT LoanITem ON
where do i put this statment
SET IDENTITY_INSERT LoanITem ON [/SIZE][/QUOTE]
From Query analyzer before adding the data and you can execute it at runtime in your SPs.