Tag: sql-server

All the articles with the tag "sql-server".

• 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.

• 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.

• sqlcmd - Get real sql error line number

  6 Jan, 2015

  A PowerShell wrapper for sqlcmd that maps batch-relative error line numbers back to the real script line.