SQL Basic- SQL Commands



          SQL Commands          


            The SQL commands to interact with relational databases are:
  • CREATE, 
  • SELECT, 
  • INSERT, 
  • UPDATE, 
  • DELETE and 
  • DROP. 


            These commands can be classified into groups based on their nature:


          DDL - Data Definition Language.

          DML - Data Manipulation Language.

          DCL - Data Control Language.


Popular posts from this blog

Rules for Constructing Character Constants

Rules for Constructing Character Constants A character constant is a single alphabet. A single digit or a single special symbol enclosed within single inverted commas .  Both the inverted commas should point to the left. For example:                      ’A’ is a valid character constant whereas ‘A’ is not. The maximum length of a character constant can be 1 character. Ex.:  'A' 'I' '5' '='
Read more

My Bisalpur- Population

Population The city is divided into 25 wards for which elections are held every 5 years. The Bisalpur Nagar Palika Parishad has population of 73,551 of which 38,858 are males while 34,693 are females as per report released by Census India 2011. Population of Children with age of 0-6 is 10242 which is 13.93 % of total population. In Bisalpur, Female Sex Ratio is of 893 against state average of 912. Moreover Child Sex Ratio in Bisalpur is around 913 compared to Uttar Pradesh state average of 902. Literacy rate of Bisalpur city is 61.65 % lower than state average of 67.68 %. Male literacy is around 68.96 % while female literacy rate is 53.43 %. Bisalpur Religion Data 2011 Town Bisalpur Population 73,551 Hindu 53.54% Muslim   45.93% Christian 0.18% Sikh 0.01% Buddhist 0.01% Jain 0.01% Others 0.00% Not Stated 0.06% My Bisalpur Related Topic: My Bisalpur- Introdution ,   Bisalpur Population
Read more

How to bind dropdownlist inside gridview edit template

Image
Overview:   This article explains how to bind drop down list control which is placed inside Asp.net   Gridview  control under Edit Template. .i.e Gridview edit template dropdownlist bind. Also using  DataRowView  we able to get and set gridview edit template drop-down list value. On ".aspx" Page: Add gridview on design page like: On ".aspx.cs" Page: Page_load Bind gridview control: Yeah, we are done now :-) Hope you enjoyed this tutorial. If you have any recommendations, please let us know what you think in the comment section below! See you again next time!
Read more