gvilbis
asked on
how do i set identity on in SQL?
i am using the following command:
insert into [wf10taa_test].[dbo].[cutd etail] select * FROM [wf10taa].[dbo].[cutdetail ] where cutno = '9701373'
and i am receiving the followig error when i run it:
An explicit value for the identity column in table 'wf10taa_test.dbo.cutdetai l' can only be specified when a column list is used and IDENTITY_INSERT is ON.
what i have to do to allow this line to run? and after i finish do i need to set off? how?
Thanks
insert into [wf10taa_test].[dbo].[cutd
and i am receiving the followig error when i run it:
An explicit value for the identity column in table 'wf10taa_test.dbo.cutdetai
what i have to do to allow this line to run? and after i finish do i need to set off? how?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SET IDENTITY_INSERT [wf10taa_test].[dbo].[cutd
go
insert into [wf10taa_test].[dbo].[cutd
SET IDENTITY_INSERT [wf10taa_test].[dbo].[cutd
go
error:
An explicit value for the identity column in table 'wf10taa_test.dbo.cutdetai
i must to put all the columns names? but i have many columns, is there a shortage way to do it instead to type all the columns names? it will take a long time?
Thanks