Skip to content

Latest commit

 

History

History
33 lines (21 loc) · 647 Bytes

README.md

File metadata and controls

33 lines (21 loc) · 647 Bytes

SQL Server Cheatsheet

Shortcuts

Command Action
Ctrl+Home Cursor to the beginning of the document
Ctrl+G Go to line
Ctrl+U Make the selected text lower case
Ctrl+Shift+U Make the selected text upper case
Ctrl+K, Ctrl+C Comment the text
Ctrl+H Replace text
Ctrl+Tab Toggle between tabs
Ctrl+L Display execution plan
Alt+F5 Start debugging from the first line

DECLARE and SET Varibales

DECLARE @my_var int
SET @my_var = 1
SELECT @my_var = xy FROM my_table WHERE id=1