SQL Server Returns the intersection of two strings

Use JavaScript Arrays for calculation, Code As follows: Copy code The Code is as follows: Use tempdb
Go
If (object_id ('fn _ getarray') is not null)
Drop function DBO. fn_getarray
Go
Create Function fn_getarray (@ every 1 varchar (8000), @ every 2 varchar (8000 ))
Returns varchar (8000)
As
Begin
Declare @ STR varchar (8000)
Set @ STR ='
VaR A = [''' + Replace (@ override 1, ',', ''', ''') + '''];
VaR B = [''' + Replace (@ override 2, ',', ''', ''') + '''];
VaR c = ""
For (VAR I = 0; I <A. length; I ++)
{
For (var j = 0; j <B. length; j ++)
{If (a [I] = B [J] & C. indexof (A [I]) <0)
C + = A [I] + ","
}
}
'
Declare @ object int
Declare @ r varchar (800)
Exec sp_oacreate 'msscriptcontrol. scriptcontrol', @ object output
Exec sp_oasetproperty @ object, 'language ', 'javascript'
Exec sp_oamethod @ object, 'eval', @ r out, @ Str
Return @ r
End
Go
Select DBO. fn_getarray ('abc, dced, f23e, gew432', '23c, ABC, f23e, geafd, ged ')
/* Output
ABC, f23e,
*/