选择查询SQL时如何添加空白行

虽然我不了解执行此任务的原因，但是无论如何您都可以这样做：

DECLARE @t TABLE ( ID INT )DECLARE @c INT  = 8INSERT  INTO @tVALUES  ( 1 ),        ( 2 ),        ( 3 );WITH    cte          AS ( SELECt   1 AS rn    UNIOn ALL    SELECT   rn + 1    FROM     cte    WHERe    rn <= @c  )    SELECt TOP ( @c ) *    FROM    ( SELECt    ID   FROM      @t   UNIOn ALL   SELECt    NULL   FROM      cte ) t    ORDER BY ID DESC

输出：

ID321NULLNULLNULLNULLNULL