Tuesday, November 6, 2012
State of the Species Does success spell doom for Homo sapiens?
This was an absolutely amazing article in Orion Magazine. Why we may or may not go extinct. http://www.orionmagazine.org/index.php/articles/article/7146
Monday, November 5, 2012
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:
And made it this:
Thank You Internet and Thank you Tao Klerks.
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 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 VARCHAR(4000),@GuidesheetItems VARCHAR(4000),@GuidesheetStatus VARCHAR(100))RETURNS VARCHAR(200)ASBEGINDECLARE @VCOMMETS VARCHAR(4000)... more of same ...'ITEMS','ITEM')SET @V_VALUE = @VGuidesheetItemsRETURN @V_VALUEEND
Thank You Internet and Thank you Tao Klerks.
Subscribe to:
Posts (Atom)