by websolete | Nov 12, 2017 | ColdFusion, DBX, SQL Server
While I still don’t actively work on DBX anymore, I did have occasion to work on a client using SQLServer and took the opportunity to add/enhance a few things that were annoying me: added a filter for the left-hand TOC which does simple string-matching to filter...
by websolete | Feb 26, 2015 | SQL Server
Needed a function to de-duplicate string lists, so I modified a similar UDF from SQLAuthority. That original UDF didn’t preserve the position of list elements or handle case sensitive comparisons, and I wasn’t too keen on the variable naming. Anyway, my...
by websolete | Feb 26, 2011 | ColdFusion, DBX, SQL Server
This update allows DBX to display included columns when enumerating indexes for tables. Based off the sp_helpindex2 stored procedure from http://www.sqlskills.com. Download from here.
by websolete | Jan 23, 2009 | ColdFusion, DBX, SQL Server
A bug fix and a minor change: – fixed miscalculation of total in database/table info pane – changed sort in extended properties tab for 2005/2008 tables/views to match the ordinal position of the column
by websolete | Dec 9, 2008 | ColdFusion, DBX, SQL Server
Minor fix in this version: – added handling for stored html content display in data sample tab
by websolete | Nov 18, 2008 | SQL Server
I needed an efficient and reusable way to get character counts in strings at the database level and produced the following udf which takes a string and a character and returns the number of occurrences of the character in the string. CREATE FUNCTION...
