SQL compares the way a set exists in another set sharing _mssql

Copy Code code as follows:

DECLARE @c INT
DECLARE @c2 INT
SELECT @c = COUNT (1)
FROM dbo. Splittotable (' 1|2|3|4 ', ' | ')
SELECT @c2 =count (1)
FROM dbo. Splittotable (' 1|2|3|4 ', ' | ') a
INNER JOIN dbo. Splittotable (' 1|2|3| ', ' | ') b on a.value = B.value
IF @c = @c2
SELECT ' OK '
ELSE
SELECT ' No '
Splittotable This function is as follows:
Set ANSI_NULLS on
SET QUOTED_IDENTIFIER ON
Go
ALTER FUNCTION [dbo]. [Splittotable]
(
@SplitString NVARCHAR (MAX),
@Separator NVARCHAR (10) = '
)
RETURNS @SplitStringsTable TABLE
(
[id] INT IDENTITY (1, 1),
[Value] NVARCHAR (MAX)
)
As
BEGIN
DECLARE @CurrentIndex INT;
DECLARE @NextIndex INT;
DECLARE @ReturnText NVARCHAR (MAX);
SELECT @CurrentIndex = 1;
while (@CurrentIndex <= LEN (@SplitString))
BEGIN
SELECT @NextIndex = CHARINDEX (@Separator, @SplitString,
@CurrentIndex);
IF (@NextIndex = 0
OR @NextIndex is NULL
)
SELECT @NextIndex = LEN (@SplitString) + 1;
SELECT @ReturnText = SUBSTRING (@SplitString,
@CurrentIndex,
@NextIndex-@CurrentIndex);
INSERT into @SplitStringsTable
([value])
VALUES (@ReturnText);
SELECT @CurrentIndex = @NextIndex + 1;
End
return;
End