INSERT INTO [dbo].[CXBarcode] ([ID], [CreationDate], [BarcodeNO], [CreationUse]) VALUES (@ID, @CreationDate, @BarcodeNO, @CreationUse) SELECT ID, CreationDate, BarcodeNO, CreationUse FROM dbo.CXBarcode