use Split function to Split the String by ';'
CREATE FUNCTION [dbo].[Split]
(
@String NVARCHAR(4000),
@Delimiter NCHAR(1)
)
RETURNS TABLE
AS
RETURN
(
WITH Split(stpos,endpos)
AS(
SELECT 0 AS stpos, CHARINDEX(@Delimiter,@String) AS endpos
UNION ALL
SELECT endpos+1, CHARINDEX(@Delimiter,@String,endpos+1)
FROM Split
WHERE endpos > 0
)
SELECT 'Id' = ROW_NUMBER() OVER (ORDER BY (SELECT 1)),
'Data' = SUBSTRING(@String,stpos,COALESCE(NULLIF(endpos,0),LEN(@String)+1)-stpos)
FROM Split
)
GO
SELECT * FROM [dbo].[Split] ('A50EA54A-BE80-41EC-BBDF-3EA2551F56C7;349D83CB-B3F7-4553-8D87-01F24222295E;DDB62DC7-7C41-4EDA-8DF6-101C05F3A3A6;32F2B8D0-8733-46E6-B508-20DD87534744;709FECD2-CF4C-4051-B339-E14D78829B31;2363E968-5852-488A-876E-E39EEEF0A8D1;016C8661-B321-49C0-8973-FF9CC0DF528A', ';')
sql doesn't Provide arrays instead of that you can use temporary Table to store the Data'.