Home

SSMS Custom Reports

• Creating custom reports, and the variables that get passed in
  • http://www.mssqlinsider.com/2011/03/how-to-create-custom-reports-for-sql-server-management-studio/

SSMS Settings

• Line Split copying from SSMS Results to Excel
  • "In SSMS before 2012, the carriage return (\n\r) wasn't taken into consideration when copying data from SQL Server to Excel. This behaves in a different way in SQL Server 2012, as it preserves the carriage return (\n\r) and therefore splits the row into multiple rows in Excel when pasting."
    • https://www.mssqltips.com/sqlservertip/3416/line-split-issues-when-copying-data-from-sql-server-to-excel/
  • \n = CHAR(13)
  • \r = CHAR(10)
  • In SSMS 2012+ , this is fixed by adding a new option Retain CR\LF on copy or save under the Tools -> Options... menu, Query Results -> SQL Server -> Results to Grid.
    • https://stackoverflow.com/a/33420616
    • https://stackoverflow.com/questions/13380779/new-line-issue-when-copying-data-from-sql-server-2012-to-excel
• PresentEdit
• RegEdit
  • \r
  • ^ and $
• F1 direct help
• Brackets when dragged
  • Tools
  • =>Options
  • => SQL Server Object Explorer
  • => Drag/Drop
  • => Surround object names with brackets when dragged
• Full screen Shift+Alt+Enter
• Surround Code
  • Ctrl+K,Ctrl+S
• Filter Object Explorer
• Reduce ALL white space
  • Ctrl+K,Ctrl+\
• Comment line results
  • SELECT '- -' as '- -'
• SET NOEXEC ON
  • New File Template
  • SQLFile.sql
  • C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\SqlWorkbenchProjectItems\Sql\