CREATE PROCEDURE EXEC$A_Int_COUNT_test
                 @str    nvarchar(MAX),
                 @retdata  bit = 1,
                 @tookms   int = NULL OUTPUT AS

DECLARE @start datetime2(3)
SELECT @start = sysdatetime()

EXEC('
DECLARE @cnt bigint
SELECT @cnt = SUM(len(word))
FROM   usrdictwords u
WHERE  wordno IN (' + @str + ')
')

SELECT @tookms = datediff(ms, @start, sysdatetime());


go

CREATE PROCEDURE EXEC$A_Int_JOIN_test
                 @str    nvarchar(MAX),
                 @retdata  bit = 1,
                 @tookms   int = NULL OUTPUT AS

DECLARE @start datetime2(3)
SELECT @start = sysdatetime()

EXEC('
INSERT #Int_JOIN (word)
SELECT u.word
FROM   usrdictwords u
WHERE  wordno IN (' + @str + ')
')

SELECT @tookms = datediff(ms, @start, sysdatetime());

IF @retdata = 1 SELECT word FROM #Int_JOIN
TRUNCATE TABLE #Int_JOIN

go

CREATE PROCEDURE EXEC$A_Str_COUNT_test
                 @str    nvarchar(MAX),
                 @retdata  bit = 1,
                 @tookms   int = NULL OUTPUT AS

DECLARE @start datetime2(3)
SELECT @start = sysdatetime()

EXEC('
DECLARE @cnt bigint
SELECT @cnt = SUM(len(guid))
FROM   usrdictwords u
WHERE  u.word IN (' + @str + ')
')

SELECT @tookms = datediff(ms, @start, sysdatetime());


go

CREATE PROCEDURE EXEC$A_Str_JOIN_test
                 @str      nvarchar(MAX),
                 @retdata  bit = 1,
                 @tookms   int = NULL OUTPUT AS

DECLARE @start datetime2(3)
SELECT @start = sysdatetime()

EXEC('
INSERT #Str_JOIN (wordno, guid)
SELECT u.wordno, u.guid
FROM   usrdictwords u
WHERE  u.word IN (' + @str + ')
')

SELECT @tookms = datediff(ms, @start, sysdatetime());

IF @retdata = 1 SELECT wordno FROM #Str_JOIN
TRUNCATE TABLE #Str_JOIN

go