[步骤]
declare @p4 dbo.Tb_StringIds insert into @p4 values(N'16003534')insert into @p4 values(N'5911141')insert into @p4 values(N'17324070')insert into @p4 values(N'10406991')insert into @p4 values(N'4478274')insert into @p4 values(N'6351419')insert into @p4 values(N'18518651')insert into @p4 values(N'17851812')insert into @p4 values(N'16001324')insert into @p4 values(N'3643662')insert into @p4 values(N'13965249')insert into @p4 values(N'13603515')insert into @p4 values(N'13972329')insert into @p4 values(N'16616790')insert into @p4 values(N'6879745')insert into @p4 values(N'16352744')insert into @p4 values(N'10558952')insert into @p4 values(N'5806637')insert into @p4 values(N'3794825')insert into @p4 values(N'13668422')insert into @p4 values(N'6733216')insert into @p4 values(N'2943453')insert into @p4 values(N'12067202')insert into @p4 values(N'17354241')insert into @p4 values(N'15815726')insert into @p4 values(N'13089022')insert into @p4 values(N'13089026')insert into @p4 values(N'17451249')insert into @p4 values(N'16748151')insert into @p4 values(N'16427933')insert into @p4 values(N'17492682')insert into @p4 values(N'17487949')insert into @p4 values(N'18561727')insert into @p4 values(N'8884484')insert into @p4 values(N'17176199')insert into @p4 values(N'18739636')insert into @p4 values(N'6645864')insert into @p4 values(N'17273731')insert into @p4 values(N'16719751')insert into @p4 values(N'17151268')insert into @p4 values(N'18101287')insert into @p4 values(N'16788434')insert into @p4 values(N'16253418')insert into @p4 values(N'18654431')insert into @p4 values(N'13713092')insert into @p4 values(N'18687577')insert into @p4 values(N'15404830')insert into @p4 values(N'15456875')insert into @p4 values(N'8709456')insert into @p4 values(N'6268688')insert into @p4 values(N'17941779')insert into @p4 values(N'16236145')insert into @p4 values(N'14630475')insert into @p4 values(N'9075727')insert into @p4 values(N'13339727')insert into @p4 values(N'13725712')insert into @p4 values(N'4311831')insert into @p4 values(N'4875206')insert into @p4 values(N'6354426')insert into @p4 values(N'14728033')insert into @p4 values(N'17428367')insert into @p4 values(N'13760655')insert into @p4 values(N'14144882')insert into @p4 values(N'12328372')insert into @p4 values(N'4540760')insert into @p4 values(N'13417000')insert into @p4 values(N'3693416')insert into @p4 values(N'17917430')insert into @p4 values(N'5721147')insert into @p4 values(N'14936022')insert into @p4 values(N'13785436')insert into @p4 values(N'2762305')insert into @p4 values(N'11627359')insert into @p4 values(N'13409268')insert into @p4 values(N'8865716')insert into @p4 values(N'8502428')insert into @p4 values(N'2957078')insert into @p4 values(N'5989665')insert into @p4 values(N'3584577')insert into @p4 values(N'17032399')insert into @p4 values(N'14591885')insert into @p4 values(N'3352418')insert into @p4 values(N'17269318')insert into @p4 values(N'18560279')insert into @p4 values(N'14036252')insert into @p4 values(N'3034788')insert into @p4 values(N'6145713')insert into @p4 values(N'17950795')insert into @p4 values(N'11652554')insert into @p4 values(N'16765732')insert into @p4 values(N'16598369')insert into @p4 values(N'18451346')insert into @p4 values(N'17659815')insert into @p4 values(N'12862828')insert into @p4 values(N'2328542')insert into @p4 values(N'2937540')insert into @p4 values(N'18616650')insert into @p4 values(N'18580650')insert into @p4 values(N'14760506')insert into @p4 values(N'16890009')exec sp_executesql N' SELECT alias.[ID],alias.[CustomerID],alias.[SKU],alias.[RecommendValue],alias.[AddAdminID],alias.[AddAdminName],alias.[AddTime],alias.[ToDevelopMemo],alias.[DevelopStatus],alias.[DevelopAdminID],alias.[DevelopAdminName],alias.[DevelopTime],alias.[DevelopRefuseReason],alias.[DevelopRefuseTime],alias.[AssignDevelopAdminID],alias.[AssignDevelopAdminName],alias.[ToEditorAttachment],alias.[ToEditorMemo],alias.[EditStatus],alias.[EditAdminID],alias.[EditAdminName],alias.[EditTime],alias.[EditRefuseReason],alias.[EditRefuseTime],alias.[ToImageMemo],alias.[ImageStatus],alias.[ImageAdminID],alias.[ImageAdminName],alias.[ImageTime],alias.[ImageRefuseReason],alias.[ImageRefuseTime],alias.[BuyerID],alias.[BuyerName],alias.[BuyerSetTime],alias.[CheckStatus],alias.[CheckReason],alias.[CheckAdminID],alias.[CheckAdminName],alias.[CheckTime],alias.[OnlineTime],alias.[OfflineTime],alias.[OfflineAdminID],alias.[OfflineAdminName],alias.[CopyProductID],alias.[PackageCommission],alias.[PickingCommission],alias.[ToProcurementCheckMemo],alias.[PriceAdminID],alias.[PriceAdminName],alias.[PriceSpecialistOperatTime],alias.[ToDeliveryPackNoteMemo],alias.[IsEditRemarkApplyAllVariants],alias.[ProductDevelopmentAuditTime],alias.[ProductEditAuditTime],alias.[ProductPictureAuditTime],alias.[ProductStatusModifyTime],alias.[ProductPropertyModifyTime],alias.[UpdateTime],alias.[DevelopmentAuditOperatorId],alias.[DevelopmentAuditOperatorName],alias.[EditAuditOperatorId],alias.[EditAuditOperatorName],alias.[PictureAuditOperatorId],alias.[PictureAuditOperatorName],alias.[SetStopProductionTime],alias.[SetStopProductionOperatorId],alias.[SetStopProductionOperatorName],alias.[SetShortageTime],alias.[SetShortageOperatorId],alias.[SetShortageOperatorName],alias.[SetClearLibraryTime],alias.[SetClearLibraryOperatorId],alias.[SetClearLibraryOperatorName],alias.[SettingUpImitationCardsOperatorId],alias.[SettingUpImitationCardsOperatorName],alias.[SettingMoldingsTime],alias.[IsAmazonSale],alias.[NoSalePlatform],alias.[PhotographerId],alias.[PhotographerName],alias.[PhotographerTime],alias.[IntellectualPropertyRightsAdminID],alias.[IntellectualPropertyRightsAdminName],alias.[IntellectualPropertyRightsTime],alias.[NoSaleCountry],alias.[WrapDesignerId],alias.[WrapDesignerName],alias.[WrapDesignerTime],alias.[ImageDesignerId],alias.[ImageDesignerName],alias.[ImageDesignerTime],alias.[AssignDevelopTime],alias.[CompeteAsin],alias.[IsRiskControlEnquiry],alias.[RiskControlEnquiryAdminId],alias.[RiskControlEnquiryAdminName],alias.[RiskControlEnquiryTime],alias.[RiskLevelType],alias.[RiskLevelRemark],alias.[RiskLevelAdminId],alias.[RiskLevelAdminName],alias.[RiskLevelTime],alias.[HasImitationCountry],alias.HasPattern FROM RB_Product_Admin alias(NOLOCK) INNER JOIN @tb_SKUs tmp ON alias.SKU=tmp.Id AND alias.CustomerID=@CustomerID',N'@CustomerID int,@tb_SKUs [Tb_StringIds] READONLY',@CustomerID=1,@tb_SKUs=@p4
传入类型 包含 N ，不需要做unicode 处理 @p4 values(N'16598369')
[结果]
[期望]
数据量不大 建议直接 IN（ 几十个 问题不大）注意类型 ，不需要采用表传值类型转换，临时表被滥用 磁盘压力大