Thread: Error in Insert Function

HI,
when I try to insert few rows for category table I get this error.
Could any one tell me what I can do to be able to execute this query.

Code:

INSERT INTO Category (CategoryID, CategoryGUID, [Name], Summary, [Description], SEKeywords, SEDescription, DisplayPrefix, SETitle, SENoScript, SEAltText, ParentCategoryID, ColWidth, SortByLooks, DisplayOrder, RelatedDocuments, XmlPackage, Published, AllowSectionFiltering, AllowManufacturerFiltering, AllowProductTypeFiltering, QuantityDiscountID, ShowInProductBrowser, SEName, ExtensionData, ContentsBGColor, PageBGColor, GraphicsColor, ImageFilenameOverride, IsImport, [Deleted], CreatedOn, PageSize, Wholesale, TaxClassID, SkinID, TemplateName) VALUES (13, '{671A6F82-2FDC-4603-B00C-1ABCD6D55C2F}', 'Norstar', '', '', NULL, NULL, NULL, NULL, NULL, NULL, 0, 4, 0, 5, NULL, 'entity.gridwithprices.xml.config', 1, 0, 0, 0, 0, 1, 'norstar', NULL, '', '', '', '', 0, 1, '2005-12-13 17:15:46', 20, 1, 1, 0, '');
COMMIT
GO

Cannot insert explicit value for identity column in table 'Category' when IDENTITY_INSERT is set to OFF.

You just need to turn identity inserts on. Do something like this:

Code:

set IDENTITY_INSERT [dbo].Category ON;
INSERT INTO Category (CategoryID, CategoryGUID, [Name], Summary, [Description], SEKeywords, SEDescription, DisplayPrefix, SETitle, SENoScript, SEAltText, ParentCategoryID, ColWidth, SortByLooks, DisplayOrder, RelatedDocuments, XmlPackage, Published, AllowSectionFiltering, AllowManufacturerFiltering, AllowProductTypeFiltering, QuantityDiscountID, ShowInProductBrowser, SEName, ExtensionData, ContentsBGColor, PageBGColor, GraphicsColor, ImageFilenameOverride, IsImport, [Deleted], CreatedOn, PageSize, Wholesale, TaxClassID, SkinID, TemplateName) VALUES (13, '{671A6F82-2FDC-4603-B00C-1ABCD6D55C2F}', 'Norstar', '', '', NULL, NULL, NULL, NULL, NULL, NULL, 0, 4, 0, 5, NULL, 'entity.gridwithprices.xml.config', 1, 0, 0, 0, 0, 1, 'norstar', NULL, '', '', '', '', 0, 1, '2005-12-13 17:15:46', 20, 1, 1, 0, '');
COMMIT
GO
set IDENTITY_INSERT [dbo].Category OFF;

Thanks a lot