CREATE PROCEDURE ParseList @list xml AS BEGIN DECLARE @Ids TABLE(Id uniqueidentifier) INSERT INTO @Ids SELECT T.Ids.value('.', 'uniqueidentifier') FROM @list.nodes('/ArrayOfGuid/guid') AS T(Ids) SELECT * FROM @Ids END GO
EXEC ParseList
N' 699f9527-1f9d-4a00-937b-a7637b0a8c03 f766e5fb-27a7-4171-bf0c-c0e093baed27 c22b2aa6-541e-495f-b315-233c0ed0e7a7 ccf83d1e-5809-4214-a5a9-416ce22e62ca ' go
No comments:
Post a Comment