Редактировал(а) Alexandr Fokin 2023/12/16 14:13
  • Alexandr Fokin
    Alexandr Fokin, 2020/03/25 15:50

    1)
    select *
    from dbo.MainEntities
    where I in (1000,1001,1002 ...)

    2)
    DROP TABLE IF EXISTS #TmpData

    CREATE TABLE #TmpData
    (ID INT)


    INSERT INTO #TmpData
    VALUES (1000), (1001), (1002), ...

    ...

    SELECT *
    FROM #TmpData td
    JOIN dbo.MainEntities me on td.ID = me.I

    DROP TABLE IF EXISTS #TmpData

    3)
    Declare @idList xml = '
    <ArrayOfInt>
      <int>1000</int>
      <int>1001</int>  
      ...
    </ArrayOfInt>'

    Select
    me.*
    From @idList.nodes('/ArrayOfInt/int') AS idList(id)
       JOIN dbo.MainEntities me on idList.id.value('.', 'int') = me.I