C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

ShotCuts in SQL Server

Posted Date: 02 May 2008 Resource Type: Tips Category: General

Posted By: Asha Mathews Member Level: Gold
Rating:

Points: 15

Shortcuts:

2000 – Start->Run-> "isqlw" –To open a query analyzer in 2000

2005 – Start->Run-> "sqlwb" —To open SSMS in 2005 (Not Query analyzer For New Query use Alt+N)

2005 – Start->Run-> "ssmsee" —TO open SSMS in 2005 (Express Edition)

The most commonly used keyboard shortcuts in the SQL Server Management Studio (SSMS).

Start->Run-> and then SqlWb.exe to launch SQL Server Management Studio

Results in Grid
Ctrl + D

Change database
Ctrl + U

Results in Text
Ctrl + T

Execute Query
Ctrl + E or F5

Show/Hide Object browser
F8 (Auto Hide has to be enabled)

New Query Window
Ctrl + Q

New Query with New Connection
Ctrl + N (Then selecting SQL Server Query template)

Open a .SQL Script file
Ctrl + O

Full Screen
Shift + Alt + Enter

Parse the query
Ctrl + F5

Show/Hide Results Pane
Ctrl + R

Switch between query and results panes
F6

Information about all the objects in the current database
Alt + F1

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Difference between Console, Windows, Web applications and Web services
	Previous Resource: Standards for Writing SQL Queries
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

teleconferencing