Bookmarks: Clear all bookmarks.
|
CTRL-SHIFT-F2
|
Bookmarks: Insert or remove a bookmark (toggle).
|
CTRL+F2
|
Bookmarks: Move to next bookmark.
|
F2
|
Bookmarks: Move to previous bookmark.
|
SHIFT+F2
|
Cancel a query.
|
ALT+BREAK
|
Connections: Connect.
|
CTRL+O
|
Connections: Disconnect.
|
CTRL+F4
|
Connections: Disconnect and close child window.
|
CTRL+F4
|
Database objects information.
|
ALT+F1
|
Editing: Clear the active Editor pane.
|
CTRL+SHIFT+ DEL
|
Editing: Comment out code.
|
CTRL+SHIFT+C
|
Editing: Copy. You can also use CTRL+INSERT.
|
CTRL+C
|
Editing: Cut. You can also use SHIFT+DEL.
|
CTRL+X
|
Editing: Decrease indent.
|
SHIFT+TAB
|
Editing: Delete through the end of a line in the Editor
pane.
|
CTRL+DEL
|
Editing: Go to a line number.
|
CTRL+G
|
Editing: Increase indent.
|
TAB
|
Editing: Make selection lowercase.
|
CTRL+SHIFT+L
|
Editing: Make selection uppercase.
|
CTRL+SHIFT+U
|
Editing: Remove comments.
|
CTRL+SHIFT+R
|
Editing: Repeat last search or find next.
|
F3
|
Editing: Replace.
|
CTRL+H
|
Execute a query. You can also use CTRL+E (for backward
compatibility).
|
F5
|
Books Online
|
F1
|
Help for the selected Transact-SQL statement.
|
SHIFT+F1
|
Navigation: Switch between query and result panes.
|
F6
|
Navigation: Switch panes.
|
Shift+F6
|
Navigation: Window Selector.
|
CTRL+W
|
New Query window.
|
CTRL+N
|
Object Browser (show/hide).
|
F8
|
Object Search.
|
F4
|
Parse the query and check syntax.
|
CTRL+F5
|
Results: Display results in grid format.
|
CTRL+D
|
Results: Display results in text format.
|
CTRL+T
|
Results: Move the splitter.
|
CTRL+B
|
Results: Save results to file.
|
CTRL+SHIFT+F
|
Results: Show Results pane (toggle).
|
CTRL+R
|
Templates: Insert a template.
|
CTRL+SHIFT+INSERT
|
Templates: Replace template parameters.
|
CTRL+SHIFT+M
|
Tuning: Display estimated execution plan.
|
CTRL+L
|
Tuning: Display execution plan (toggle ON/OFF).
|
CTRL+K
|
Tuning: Index Tuning Wizard.
|
CTRL+I
|
Tuning: Show client statistics
|
CTRL+SHIFT+S
|
Tuning: Show server trace.
|
CTRL+SHIFT+T
|
Use database.
|
CTRL+U
|
Q: What is SSRS? Ø SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø It is used for preparing and delivering interactive and variety of reports. Ø It is administered through an web based interface. Ø Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...
Thanks for your feedback
ReplyDelete