select值必须与插入列的数量相匹配
我有以下查询…检查并重新检查insert和select语句中的值的types和数量。 我无法弄清楚什么是错的。 insert into [Subscription].dbo.SUBSCRIPTION ( CreateDate, StartDate, ProductId, Processor, IntervalType, IntervalLength, TotalOccurrences, TrialOccurrences, Status, Amount, –10 TrialAmount, FirstName, LastName, Address, City, State, Zip, Country, Phone, Email, –20 CardNumber, CardExpMonth, CardExpYear, Custom1, Custom2, Custom3, SecurityCode, CancellationDate, ApplicationName, OfferTypeID, –30 OfferID, CampaignID, SubID, OrderID) –34 items select o.CreateDate, DATEADD(day, 4, o.createdate) as startdate, '3B85ECD0-6CC0-4A68-BFB1-922ADC74F5B0' 'cb_test', 1, […]