SHASHANGKA SHEKHAR'S BLOG

Hi, I am Shashangka Shekhar, Working with Microsoft Technologies. This is my personal blog where I share some of my experiences.

The History of SQL Server

SQL stands for Structured Query Language and is pronounced either ess-que-el orsequel. It is the language used by relational database management systems (RDBMS) to access and manipulate data and to create, structure and destroy databases and database objects. Read More

Keyboard Shortcuts in SQL

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

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

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

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?

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

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

Delegates

In this article we will try to understand what is delegate, how to use it.

Dictionary meaning:A person sent or authorized to represent others “or “A person designated to act for or represent another or others

Read More

Classes in C#.Net

A class is a blueprint, that defines the attributes and behaviors of the objects, that are created as instances of the class.

Classes are declared by using the keyword class followed by the class name and a set of class members surrounded by curly braces. Every class has a constructor, which is called automatically any time an instance of a class is created. The purpose of constructors is to initialize class members when an instance of the class is created. Read More