Tag:sql

All the articles with the tag "sql".

• Efficiently debug stored procedure in SSMS

  26 Nov, 2019

  A Stack Overflow question seeking community input on efficient techniques for debugging stored procedures in SQL Server Management Studio.

• Post SQL output to bug tracker details - Mr. Data Converter

  11 Oct, 2019

  Mr. Data Converter converts SSMS query results copied with headers into formatted markdown or wiki tables for pasting into bug trackers.

• My new favorite SQL toy - ApexSQL Refactor

  20 Dec, 2016

  ApexSQL Refactor is a highly configurable SQL formatter for SSMS, with a known bug that can incorrectly move SELECT statements inside IF blocks.

• Perfectionist's hell or SQL formatting

  14 Sep, 2015

  Frustration with existing SQL formatters and a call for community input on automatic SQL code formatting tools.

• SQL Server Management Studio and very large strings

  18 Feb, 2015

  Working around SSMS truncation of nvarchar(max) strings during concatenation and result copying via FOR XML PATH.