sql server使用in关键字传递字符串数组查询

您误解了SQL Server中字符串的处理方式。你有的字符串（

‘’’Sales Entry Grid Cursor’’,’’Customer Mandatory’’,’’Coloum Uom’’,’’Show Marka’’,’’Show Discount Amount In Grid’’,’’Show Discount % In Grid’’,’’Calculation based on Weight *rate’’’

）是
的
一
</强>
字面值，而不是多个值。

IN

不会对它“起作用”，因为它正在寻找一行具有整个字符串的值

PageConfig_settingsName

。

    
      SELECT pageconfig_action
FROM [RetailSoft].[dbo].[tbl_pageconfig]
     CROSS APPLY STRING_SPLIT(@setting, ‘,’) SS
WHERE [PageConfig_settingsName] = SS.[value]
  AND PageConfig_CompanyId = 1;
</code>
  

    
      DECLARE @Setting table (setting varchar(255));
INSERT INTO @Setting (setting)
VALUES (‘Sales Entry Grid Cursor’),
       (‘Customer Mandatory’),
       (‘Coloum Uom’),
       (‘Show Marka’),
       (‘Show Discount Amount In Grid’),
       (‘Show Discount % In Grid’),
       (‘Calculation based on Weight *rate’);
SELECT P.pageconfig_action
FROM [RetailSoft].[dbo].[tbl_pageconfig] P
     JOIN @Setting S ON S.setting = P.[PageConfig_settingsName]
WHERE P.PageConfig_CompanyId = 1;
</code>
  

你需要做

Setting

表，而不是varchar。

然后就不需要动态的sql，你可以像这样保持简单

    
      declare @Setting table (name varchar(50))
insert into @Setting (name)
values (‘Sales Entry Grid Cursor’),
       (‘Customer Mandatory’),
       (‘Coloum Uom’),
       (‘Show Marka’),
       (‘Show Discount Amount In Grid’),
       (‘Show Discount % In Grid’),
       (‘Calculation based on Weight *rate’)
Select pageconfig_action
from   [RetailSoft].[dbo].[tbl_pageconfig]
Where  [PageConfig_settingsName] in (select name from @setting)
and    PageConfig_CompanyId=1
</code>