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

发布时间：2020-12-12 08:44:02 所属栏目：MsSql教程来源：网络整理

导读：我有很多.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.

我有很多.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

解决方法

没有内置,找到和替换可以与正则表达式一起使用,某些人可能会有一个解决方案.

（编辑：李大同）

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