将字符串列表传递给存储过程

使用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))