SQL Shortcut Archives - Page 2 of 3 - SQL Authority with Pinal Dave

SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS

August 30, 2014

SQL Server Management Studio, SQL Shortcut

I just formatted my computer and installed fresh SQL Server 2014. The very first thing which I did was to open SQL Server Management Studio and execute a sample query. As soon as I executed the query, it returned me some result. Once I did not need the result, my…

MySQL – Download MySQL Workbench Shortcut in PDF

February 2, 2014

Pinal Dave

SQL, SQL Tips and Tricks

Cheatsheet, MySQL, SQL Shortcut

MySQL Workbench is default IDE for MySQL and it is available to download for free on MySQL’s website. It is a fully featured IDE with three major sections. 1) SQL Development 2) SQL Administration and 3) Data Modeling. Each section is quite big on its own. There are plenty of…

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]

July 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Shortcut

Earlier this week I wrote a blog post about SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis, I received quite a lot of positive feedback from readers. If you are a regular reader of the blog post, you must be aware that I appreciate the learning shared by…

SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

July 7, 2012

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Shortcut

Every weekend brings creative ideas and accidents brings best unknown secrets in front of us. Just a day while working with complex SQL Server code in SSMS I came across very interesting shortcut which I have never used before and instantly fell in love with it. It is totally possible that you are familiar with this but for me it was the first time and I was surprised that I did know know this short cut so far.

SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut

November 28, 2008

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Shortcut

Many times when I am writing query I have to scroll the result displayed in the result set. Most of the developer uses the mouse to switch between and Query Pane and Result Pane. There are few developers who are crazy about the Keyboard SQL shortcut.

SQL SERVER – Query Analyzer Shortcuts – Part 2

April 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Shortcut

I enjoy reader’s articles to read as much as I enjoy expert’s articles. One of blog reader Praveen Barath always have good ideas to share. Here is Praveen Barath’s comment on my previous article Query Analyzer Shortcuts. MSSQL server 2005 is a database platform , Platform because from one window…

SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example

October 5, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility

This article is written by request and suggestion of Sr. Web Developer at my organization. Due to nature of this article most of the content are referred from Book On-Line. sqlwb command prompt utility which opens SQL Server Management Studio. sqlwb command does not run queries from command prompt. sqlcmd…