摘要:
update dbo.VersionsTree set parentId=d.ss from (SELECT Reverse(SUBSTRING(SUBSTRING(Reverse(metacode),(LEN(metaid)+4),LEN(metacode)),0,Charindex('||',SUBSTRING(Reverse(metacode),(LEN(metaid)+4),LEN(metacode)),1))) as ss,metaCode FROM [repositoryShop].[dbo].[VersionsTree]) as d where VersionsT 阅读全文