使用XML将逗号分隔的值转换为表格。使用此更新的过程。
USE [App]GOSET ANSI_NULLS onGOSET QUOTED_IDENTIFIER onGOALTER PROCEDURE [dbo].[GetWorkspaceMapDetailsForUserByGroups] @workspaceID int, @viewMap nvarchar(256) ASSELECt m.*FROM GeoAppMapDef mWHERe m.workspaceID = @workspaceID and m.IsDeleted = 0 and m.ViewMap IN ( SELECT Split.a.value('.', 'VARCHAr(100)') AS CVS FROM ( SELECT CAST ('<M>' + REPLACE(@viewMap, ',', '</M><M>') + '</M>' AS XML) AS CVS ) AS A CROSS APPLY CVS.nodes ('/M') AS Split(a))
