Langsung ke konten utama

Poor Mans T-SQL formatting add-in for Management Studio 2014

Install Poor Mans T-SQL formatting add-in for Management Studio 2014,

Master Poor Mans T-SQL from hire.
  1. Install Poor Mans T-SQL
  2. Create the folder : %SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\
  3. If it does not exist. Then just copy the file from: %SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn
  4. To : %SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn
Add Shortcut TSQL

Tool --> TQS Formating Option

set SSMS HotKey Global::F2

source : http://stackoverflow.com/questions/23303026/does-the-poor-mans-t-sql-formatting-add-in-for-management-studio-2012-work-in-ma

Komentar

Posting Komentar

Postingan populer dari blog ini

sys.processes Status sp_who2 SQL Server

Taken from the books online reference for sys.processes  and the status column. dormant = SQL Server is resetting the session. running = The session is running one or more batches. When Multiple Active Result Sets (MARS) is enabled, a session can run multiple batches. For more information, see Using Multiple Active Result Sets (MARS). background = The session is running a background task, such as deadlock detection. rollback = The session has a transaction rollback in process. pending = The session is waiting for a worker thread to become available. runnable = The task in the session is in the runnable queue of a scheduler while waiting to get a time quantum. spinloop = The task in the session is waiting for a spinlock to become free. suspended = The session is waiting for an event, such as I/O, to complete.
Posting Komentar
Baca selengkapnya