关于存诸过程临时表的一个小运用
USE [szmj] GO /****** Object: StoredProcedure [dbo].[Par_ProductDownLoad] Script Date: 05/26/2014 17:46:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description:] -- ============================================= create PROCEDURE [dbo].[Par_ProductDownLoad] @TemporaryInsertSql text, @shopid int AS BEGIN if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#TempDownload') and type='U') begin drop table #TempDownload end create table #TempDownload ( OnLineProductId varchar(50), OnLineSkuId varchar(50), ShopId int ) exec(@TemporaryInsertSql) update [PlatformSku] set SaleStatus='instock',SkuIsSync=0 where Id in(select p.ID from [PlatformSku] p where p.Id not in (select p.ID from [PlatformSku] p inner join #TempDownload t on p.ShopId=t.ShopId where p.OnLineProductId=t.OnLineProductId and p.OnLineSkuId=t.OnLineSkuId and p.ShopId=@shopid) and ShopId=@shopid) and ShopId=@shopid --select 1 from #TempDownload t where p.OnLineProductId=t.OnLineProductId and p.OnLineSkuId=t.OnLineSkuId and p.ShopId=t.ShopId and p.ShopId=@shopid --select p.Id from [PlatformSku] p where not exists (select 1 from #TempDownload t where p.OnLineProductId=t.OnLineProductId and p.OnLineSkuId=t.OnLineSkuId and p.ShopId=t.ShopId and p.ShopId=@shopid) --update [PlatformSku] set SaleStatus='instock',SkuIsSync=0 where Id in(select p.Id from [PlatformSku] p where not exists (select 1 from #TempDownload t where p.OnLineProductId=t.OnLineProductId and p.OnLineSkuId=t.OnLineSkuId and p.ShopId=t.ShopId and p.ShopId=@shopid)) and END
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步