c# - SQL 选择具有多个整数值的行

Question

我的表格包含一个整数值。我想呈现多个值，例如:

select 
    MeetingId, StartDate, EndDate, RoomId, MeetingStatusId, Subject
from 
    Meeting
where 
    RoomId in (@roomids )
    and StartDate >= @start and EndDate <= @end
    and CreatedById = @user

但如何在 C# 中将 @roomids 参数构造为整数？我尝试将 RoomId 转换为 varchar，但这没有用。

Answer 1

您可以使用 SQL Server STRING_SPLIT 函数并将参数用作 varchar:

select 
    MeetingId, StartDate, EndDate, RoomId, MeetingStatusId, Subject
from 
    Meeting
where 
    RoomId in (SELECT cast(VALUE as int) FROM dbo.string_split(@roomids) )
    and StartDate >= @start and EndDate <= @end
    and CreatedById = @user

引用:https://learn.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

如果由于您的 SQL Server 版本而没有内置拆分字符串功能，这里有一篇关于如何创建一个的文章: https://sqlperformance.com/2012/07/t-sql-queries/split-strings