I know that I can use that WSI thing but I already know Sql so im trying to write a huge insert query(with the help of a little java) to add customers to our database. I'm having trouble getting the identity insert turned on in the customer table. Does anybody see anything wrong with this query I run, It is giving an error message of
Here is a test query that failed:An explicit value for the identity column in table 'storefront.dbo.Customer' can only be specified when a column list is used and IDENTITY_INSERT is ON.
SET IDENTITY_INSERT storefront.dbo.Customer ON
insert into storefront.dbo.Customer values
(58640,'',0,{fn now()},'test@test.com','test@test.com',null,NULL,N ULL,'Admin','User','',1,'',NULL,0,NULL,NULL,1,3,0, NULL,NULL,NULL,NULL,NULL,NULL,'en-US',0.00,1,NULL,1,2,NULL,1,1,NULL,1,1,1,NULL,NULL, 0,{fn now()},1,NULL,2,'',1,1,{fn now()},1,{fn now()},1,{fn now()},1,1,NULL,NULL)