SQL Prompt Flashcards
1
Q
What is the keyboard shortcut for executing the current statement?
A
Shift + F5
2
Q
What is the keyboard shortcut for executing a query?
A
F5 or Ctrl + E
3
Q
What is the keyboard shortcut for showing code completion suggestions?
A
Ctrl + Space
4
Q
How to insert a “SELECT * FROM”-snippet?
A
ssf
5
Q
How to insert a “SELECT TOP 100 * FROM”-snippet?
A
st100
6
Q
How to insert an “ORDER BY”-snippet?
A
ob
7
Q
How to insert a “BEGIN…END” snippet?
A
be
8
Q
How to insert a “SELECT COUNT(*)… FROM”-snippet?
A
scf
9
Q
How to cancel a running query?
A
Alt + Break
10
Q
What is the difference between a “INSERT INTO … SELECT * FROM”-statement and a “SELECT * INTO … FROM …“-statement?
A
- SELECT … INTO newTbl FROM existingTbl
- INSERT INTO existingTbl SELECT * FROM existingTbl2
- SELECT INTO inserts data from an existing table into a new table while INSERT INTO inserts data from an existing table in another existing table
- With SELECT INTO the INTO statement comes after SELECT and FROM; with INSERT INTO the INSERT INTO comes before the SELECT-statement
11
Q
What is the shortcut for closing a query window?
A
Ctrl + F4
