sql-server – 如何清除SSMS中的空行？

我有很多.sql文件有很多空行,例如

WITH

  cteTotalSales (SalesPersonID,NetSales)

  AS

  (

    SELECT SalesPersonID,ROUND(SUM(SubTotal),2)

    FROM Sales.SalesOrderHeader

    WHERE SalesPersonID IS NOT NULL

    GROUP BY SalesPersonID

  )

SELECT

  sp.FirstName + ' ' + sp.LastName AS FullName,sp.City + ',' + StateProvinceName AS Location,ts.NetSales

FROM Sales.vSalesPerson AS sp

  INNER JOIN cteTotalSales AS ts

    ON sp.BusinessEntityID = ts.SalesPersonID

ORDER BY ts.NetSales DESC

有没有办法在SQL Server Management Studio中删除这些空行？这是我想要的：

WITH
  cteTotalSales (SalesPersonID,NetSales)
  AS
  (
    SELECT SalesPersonID,2)
    FROM Sales.SalesOrderHeader
    WHERE SalesPersonID IS NOT NULL
    GROUP BY SalesPersonID
  )
SELECT
  sp.FirstName + ' ' + sp.LastName AS FullName,ts.NetSales
FROM Sales.vSalesPerson AS sp
  INNER JOIN cteTotalSales AS ts
    ON sp.BusinessEntityID = ts.SalesPersonID
ORDER BY ts.NetSales DESC

解决方法

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!