SQL Server 2016 and 2017, Standard Edition
I have to insert raw data (from another table) into a table that has two
unique identifier Columns.
Requires that I use
SET IDENTITY_INSERT Carrier ON?
Here is the table:
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo],[Parkingspace]( [ParkingspaceId] [uniqueidentifier] NOT ZERO, [AccountId] [uniqueidentifier] ZERO, [ParkingspaceType] [smallint] ZERO, FORCE [PK_ParkingspaceId] PRIMARY KEY CLUSTERED ( [ParkingspaceId] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY]
Will the following work without that
IDENTITY_INSERT Possibility? (I think it should but the DBA here is very married to the
INSERT IN PARKING (ParkingspaceID, AcountID, ParkingspaceType) SELECT * FROM PRODDBCopy.Parkingspace