SHASHANGKA SHEKHAR'S BLOG

Author, TechWriter

Table Variables

Hits: 42

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: 102

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: 45

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

What’s the difference between String and string?

Hits: 52

The string type is an alias for the System.String class. It is derived from object type.

  1. String is just a class name.
  2. String is a reference type
  3. String is not a keyword and it can be used as Identifier.
  4. string is a keyword and cannot be used as Identifier.