1 / 12

Unlocking SQL Server Management Studio 2008: Essential Commands and Shortcuts

Explore the top secrets of SQL Server Management Studio 2008 with Louie Bao. Learn about startup command line parameters to easily switch databases, which is invaluable when the default database is unreachable. Enhance your productivity by using color coding for easy differentiation between development and production servers. Discover useful command techniques, including the unique GO command and essential keyboard shortcuts for efficient coding. Master advanced editing features like regex find and replace, and navigate template parameters with ease.

sachi
Télécharger la présentation

Unlocking SQL Server Management Studio 2008: Essential Commands and Shortcuts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Top secrets of SQL Server Management Studio 2008 Louie Bao

  2. Start up Command line parameters

  3. Start up Ability to change the database for the connection. Especially useful when the default database is inaccessible. Connection properties Use colours to differentiate between development and production servers.

  4. Go GoGo GO [count] GO is not a Transact-SQL statement, it is a command recognized by … and SQL Server Management Studio Code editor.

  5. Keyboard shortcuts • Word Selection: Ctrl + w • Line Selection: Home, Shift + End • Vertical Range Selection: Alt (Hold) + Click and Drag

  6. Keyboard shortcuts Advanced…

  7. Keyboard shortcuts Tools -> Options -> Environment -> Keyboard

  8. Find and replace (regex) Find what: create table:b*{\#:i} Replace with: if object_id('tempdb..\1') is not null\n\tdrop table \1\n\n\0

  9. Find and replace (regex) Find what: {[:a')]}={[@(':a]} Replace with: \1 = \2

  10. Template Template Explorer: Ctrl + Alt + T Specify Values for Template Parameters: Ctrl + Shift + M

  11. Scripting Tools -> Options -> SQL Server Object Explorer -> Scripting

  12. Tab Text Tools -> Options -> Text Editor -> Editor Tab and Status Bar

More Related