在SQL Server 2016+中：使用
string_split内置函数。请注意，不再需要多余的单引号：
DECLARE @setting varchar(max)set @setting ='Sales Entry Grid Cursor,Customer Mandatory,Column 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 value FROM string_split(@setting, ',') ) and PageConfig_CompanyId=1
如果您运行的SQL Server早于SQL 2016，则@GuidoG的答案是一种更好的方法
