SQLServer中求两个字符串的交集

使用javascript的数组来计算,代码如下: 代码如下: use tempdb go if (object_id (‘fn_getArray’ ) is not null ) drop function dbo . fn_getArray go create function fn_getArray (@ inStr1 varchar (8000 ), @ inStr2 varchar (8000 )) returns varchar (8000 ) as begin declare @ str varchar (8000 ) set @ str = ‘ var a = [”’ + re