T-SQL tip: log error details in catch

If you want to log detailed information on an error in a catch block, you can use the following code:   BEGIN CATCH declare @Message varchar(2048) = ‘<< Your custom error text here. >>’ + ‘Number: ‘ + cast(isnull(error_number(), ”) as varchar(50)) + ‘ ‘ + ‘Severity: ‘ + cast(isnull(error_severity(), …

Variable sized column with ellipsis in a table

If you want a column of a table in HTML to expand and you want the text to show "ellipsis" for overflowing text, you can use the solution found at:   http://stackoverflow.com/questions/17345158/variable-sized-column-with-ellipsis-in-a-table   Just give each cell for the specific column the following class: .expand-column { max-width: 1px; overflow: hidden; …