INSERT INTO [dbo].[BGBarcode] ([ID], [UID], [BarcodeNO], [LinesName], [WorkNo], [Product], [CheckCategory1], [CheckCategory2], [CheckCategory3], [CheckCategory4], [CheckCategory5], [CheckCategory6], [CheckCategory7], [CheckCategory8], [CheckCategory9], [CheckCategory10]) VALUES (@ID, @UID, @BarcodeNO, @LinesName, @WorkNo, @Product, @CheckCategory1, @CheckCategory2, @CheckCategory3, @CheckCategory4, @CheckCategory5, @CheckCategory6, @CheckCategory7, @CheckCategory8, @CheckCategory9, @CheckCategory10) SELECT ID, UID, BarcodeNO, LinesName, WorkNo, Product, CheckCategory1, CheckCategory2, CheckCategory3, CheckCategory4, CheckCategory5, CheckCategory6, CheckCategory7, CheckCategory8, CheckCategory9, CheckCategory10 FROM dbo.BGBarcode