SHASHANGKA SHEKHAR'S BLOG

Author, TechWriter

Table Variables

Hits: 38

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

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

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

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.

Events

Hits: 150

In this article we will try to understand what is event and how to handle and raise Events.

Note: Before start reading this article please hold a clear concept on delegates. Follow the link to read the previous article on Delegates.

Read More