sql - 有没有办法在 SQL Server Management Studio (SSMS) 中分离查询结果？

Question

我得到了一个简单的查询，它从OrderLine表中返回结果。有没有办法在视觉上分离查询结果以使其更易于阅读，就像这里显示的图像一样？

SELECT [OrderNo], [LineNo] 
FROM [OrderLine]

结果：

标签： sqlsql-serverssms

Answer 1

您可以像这样执行多个查询：

DECLARE @i int = 1
DECLARE @OrderNo
DECLARE @OrderNos TABLE (
    Idx smallint Primary Key IDENTITY(1,1)
    , OrderNo int
)

INSERT @OrderNos
SELECT distinct [OrderNo] FROM [OrderLine]

WHILE (@i <= (SELECT MAX(idx) FROM @employee_table))
BEGIN

    SET @OrderNo = (SELECT [OrderNo] FROM [OrderNos] WHERE [Idx] = @i)

    SELECT [OrderNo], [LineNo] 
    FROM [OrderLine]
    WHERE [OrderNo] = @OrderNo

    SET @i = @i + 1

END