Wednesday, August 15, 2012

T_SQL Formatter plugin for Notepad++

I have discovered the holy grail of T-Sql Formatting.  Yes, Notepad++ with Poor Man's T-SQL Formatter  which can be installed with the plugin installer built into Notepad++.  I am loathe to install third party programs for this since they are probably loaded with spyware/trojans/ads and the online versions seem to take forever or get lost in my bookmark list.  But this little baby, it took this:


USE ***GO/****** Object:  UserDefinedFunction [dbo].[FN_GET_GUIDESHEET_ITEM_INFO]    Script Date: 08/15/2012 12:13:39 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[FN_GET_GUIDESHEET_ITEM_INFO](@CLIENTID  VARCHAR(15), @PID1    VARCHAR(5), @PID2    VARCHAR(5), @PID3   VARCHAR(5), @GET_FIELD VARCHAR(200), @GuidesheetType . . . .More of same . . . = @VCOMMETS IF UPPER(@GET_FIELD) IN ('TYPE','GUIDESHEET NAME') SET @V_VALUE = @VGuidesheetType IF UPPER(@GET_FIELD) = 'STATUS' SET @V_VALUE = @VGuidesheetStatus IF UPPER(@GET_FIELD) IN ('ITEMS','ITEM') SET @V_VALUE = @VGuidesheetItems RETURN @V_VALUE END 

And made it this:

 
USE ***
GO
/****** Object:  UserDefinedFunction [dbo].[FN_GET_GUIDESHEET_ITEM_INFO]    Script Date: 08/15/2012 12:13:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[FN_GET_GUIDESHEET_ITEM_INFO] (
@CLIENTID VARCHAR(15)
,@PID1 VARCHAR(5)
,@PID2 VARCHAR(5)
,@PID3 VARCHAR(5)
,@GET_FIELD VARCHAR(200)
,@GuidesheetType VARCHAR(4000)
,@GuidesheetItems VARCHAR(4000)
,@GuidesheetStatus VARCHAR(100)
)
RETURNS VARCHAR(200)
AS
BEGIN
DECLARE @VCOMMETS VARCHAR(4000)
... more of same ...
'ITEMS'
,'ITEM'
)
SET @V_VALUE = @VGuidesheetItems
RETURN @V_VALUE
END



Thank You Internet and Thank you Tao Klerks.

No comments:

Post a Comment