Journey to SQL Authority with Pinal Dave

SQL Code Formatting is very important. Every SQL Server DBA has its own preference about formatting. I like to format all keywords to uppercase. Following are two online tools, which formats SQL Code very good. I tested following script with those tools.

use tempdb go
create procedure SP_NonFatal_INSERT @Column2 int =NULL
AS declare @ErrorMsgID int insert NonFatal
values (@Column2) set @ErrorMsgID =@@ERROR
if @ErrorMsgID 0  BEGIN
RAISerror ('An error occured updating the NonFatal table',10,1) end

Tool 1 : Instant SQL Formatter

USE TEMPDB
GO

CREATE PROCEDURE sp_NONFATAL_INSERT
                @Column2 INT  = NULL
AS
  DECLARE  @ErrorMsgID INT
  INSERT NONFATAL
  VALUES(@Column2)
  SET @ErrorMsgID =@@ ERROR
  IF @ErrorMsgID  0
    BEGIN
      RAISERROR ('An error occured updating the NonFatal table',10,1)
    END

Tool 2 : SQLinForm

USE tempdb GO
CREATE PROCEDURE
sp_NonFatal_INSERT @Column2 INT =NULL
AS
        DECLARE
        @ErrorMsgID INT
        INSERT NonFatal VALUES (@Column2) SET @ErrorMsgID =@@ERROR
        IF @ErrorMsgID 0
        BEGIN
                RAISERROR ('An error occured updating the NonFatal table',10,1)
        END