SQL Prompt

Question 1

What is the keyboard shortcut for executing the current statement?

Answer 1

Shift + F5

Question 2

What is the keyboard shortcut for executing a query?

Answer 2

F5 or Ctrl + E

Question 3

What is the keyboard shortcut for showing code completion suggestions?

Answer 3

Ctrl + Space

Question 4

How to insert a “SELECT * FROM”-snippet?

Answer 4

ssf

Question 5

How to insert a “SELECT TOP 100 * FROM”-snippet?

Answer 5

st100

Question 6

How to insert an “ORDER BY”-snippet?

Answer 6

ob

Question 7

How to insert a “BEGIN…END” snippet?

Answer 7

be

Question 8

How to insert a “SELECT COUNT(*)… FROM”-snippet?

Answer 8

scf

Question 9

How to cancel a running query?

Answer 9

Alt + Break

Question 10

What is the difference between a “INSERT INTO … SELECT * FROM”-statement and a “SELECT * INTO … FROM …“-statement?

Answer 10

• 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

Question 11

What is the shortcut for closing a query window?

Answer 11

Ctrl + F4