Tag: sql-server
All the articles with the tag "sql-server".
-
Efficiently debug stored procedure in SSMS
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
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
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
Working around SSMS truncation of nvarchar(max) strings during concatenation and result copying via FOR XML PATH.
-
sqlcmd - Get real sql error line number
A PowerShell wrapper for sqlcmd that maps batch-relative error line numbers back to the real script line.