SHASHANGKA SHEKHAR'S BLOG

Author, TechWriter

Keyboard Shortcuts in SQL

Hits: 58

This list displays the keyboard shortcuts available in SQL Query Analyzer.

CTRL+F2 :: Insert or remove a bookmark (toggle).
F2 :: Move to next bookmark.
SHIFT+F2 :: Move to previous bookmark.
ALT+BREAK :: Cancel a query. Read More

Table Variables

Hits: 39

Temp variable can be created like this:

Table variable is always useful for less data. If the result set returns a large number of records, we need to go for temp table.

Temporary Tables

Hits: 97

Types of Temporary Tables
SQL Server provides two types of temp tables based on the behavior and scope of the table. These are:

  1. Local Temp Table
  2. Global Temp Table

Read More

Views In SQL Server

Hits: 42

Let’s create a SampleDB database fist with SQL Management Studio. Now we have to create a table in SampleDB.

Let’s Name the table as – Employee

Read More