文章分类 -  Sql Server

摘要：WHILE (1=1)BEGIN UPDATE TOP(1000) [dbo].[PromotionCodeMaster] SET CurrencyCode = CASE WHEN CountryCode='USA' THEN 'USD' ... 阅读全文

摘要：INSERT INTO EcommerceLog.dbo.TempSONumber SELECT T.C.value('(.)[1]', 'INT') as SONumber, GETDATE() FROM @Xml.nodes('./SoNumber')... 阅读全文

摘要：CREATE PROCEDURE [dbo].[UP_EC_JOB_CreatePurgeUrlFromMiddle]AS SET NOCOUNT ON DELETE FROM dbo.Purge_Url_MiddleOUTPUT DELETED.Url, DELETED.I... 阅读全文