Total de postagens:
371
Karma:
2403
Ingressou:
30/06/2010
Localização:
United States
I am trying to combine 2 of the dbo.Product tables from a database called HCS and the other is nopaccu into one. I deleted half the table not thinking and want to restore that missing part to the newer table. What SQL Query will work for combining the tables while keeping the ID numbers? First table goes ID numbers 1-996 Second Table goes ID Numbers 2054-3064
Total de postagens:
371
Karma:
2403
Ingressou:
30/06/2010
Localização:
United States
I made this but it's not saving to sql? SELECT [Id] ,[Name] ,[ShortDescription] ,[FullDescription] ,[AdminComment] ,[ShowOnHomePage] ,[MetaKeywords] ,[MetaDescription] ,[MetaTitle] ,[SeName] ,[AllowCustomerReviews] ,[ApprovedRatingSum] ,[NotApprovedRatingSum] ,[ApprovedTotalReviews] ,[NotApprovedTotalReviews] ,[Published] ,[Deleted] ,[CreatedOnUtc] ,[UpdatedOnUtc] ,[ProductTemplateId] FROM [hcs].[dbo].[Product] Union SELECT [Id] ,[Name] ,[ShortDescription] ,[FullDescription] ,[AdminComment] ,[ShowOnHomePage] ,[MetaKeywords] ,[MetaDescription] ,[MetaTitle] ,[SeName] ,[AllowCustomerReviews] ,[ApprovedRatingSum] ,[NotApprovedRatingSum] ,[ApprovedTotalReviews] ,[NotApprovedTotalReviews] ,[Published] ,[Deleted] ,[CreatedOnUtc] ,[UpdatedOnUtc] ,[ProductTemplateId] FROM [nopaccu].[dbo].[Product] GO