sql格式化美化工具：SQL Pretty Printer（V4.0.0）

sql格式化美化工具：SQL Pretty Printer（V4.0.0）

格式化工具SQL Pretty Printer，格式化效果还是很好的，配置中也可以自定义格式化效果

代码格式化前后效果如下：

CREATE DATABASE Test
GO
USE Test
GO

CREATE TABLE Employees
(
Id INT IDENTITY PRIMARY KEY,
EmployeeName NVARCHAR(100),
EntryDate DATE
)

GO
 
CREATE TABLE Users
(
Id INT IDENTITY PRIMARY KEY,
UserName NVARCHAR(100),
Gender CHAR(1),
Birhdate DATETIME,
EmployeeId int
)
GO


SELECT u.UserName, e.EmployeeName FROM dbo.Users u
INNER JOIN dbo.Employees e ON e.Id = u.EmployeeId

CREATE DATABASE Test

GO

USE Test

GO

CREATE TABLE Employees
  (
     Id           INT IDENTITY PRIMARY KEY,
     EmployeeName NVARCHAR(100),
     EntryDate    DATE
  )

GO

CREATE TABLE Users
  (
     Id         INT IDENTITY PRIMARY KEY,
     UserName   NVARCHAR(100),
     Gender     CHAR(1),
     Birhdate   DATETIME,
     EmployeeId INT
  )

GO

SELECT u.UserName,
       e.EmployeeName
FROM   dbo.Users u
       INNER JOIN dbo.Employees e
               ON e.Id = u.EmployeeId 

在线版本：http://www.dpriver.com/pp/sqlformat.htm
官方下载地址：http://www.dpriver.com/dlaction.php
获取官方 licence：https://www.dpriver.com/products/sqlpp/getforfree.php