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
Calc :: Calculator
Cfgwiz32 :: ISDN Configuration Wizard
Charmap :: Character Map
Chkdisk :: Repair damaged files
Cleanmgr :: Cleans up hard drives Read More
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
Windows Logo+D :: Display the desktop
Windows Logo+E :: Open My Computer
Windows Logo+M :: Minimize all of the windows
Temp variable can be created like this:
DECLARE @temp_tblEmployee TABLE
[Emp_ID] [int] NOT NULL,
[Emp_Name] [varchar](max) NOT NULL
INSERT INTO @temp_tblEmployee
SELECT 1,'Shashangka Shekhar'
SELECT * FROM @temp_tblEmployee
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.
Types of Temporary Tables
SQL Server provides two types of temp tables based on the behavior and scope of the table. These are:
- Local Temp Table
- Global Temp Table
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
CREATE TABLE [dbo].[tblEmployee](
[Emp_ID] [int] NOT NULL,
[Emp_Name] [varchar](max) NOT NULL,
[Emp_Age] [int] NOT NULL,
[Emp_Salary] [int] NOT NULL,
[Emp_City] [varchar](max) NOT NULL,
[Emp_Gender] [char](1) NOT NULL,
CONSTRAINT [PK_tblEmployee] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
The string type is an alias for the System.String class. It is derived from object type.
- String is just a class name.
- String is a reference type
- String is not a keyword and it can be used as Identifier.
- string is a keyword and cannot be used as Identifier.
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”
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