SQL Server

SQL Introduction:

SQL is data base Programming language for accessing and manipulating databases in it database. For the Asp.net web/windows application we use SQL database.

The SQL is the set of instructions that are used to interact with a database. SQL (Structured Query Language) is the only language that most databases actually clearly understand. Whenever we interact with a database, the software translates your commands (whether they used GUI comment or queries) into SQL statement that the database knows how to work.

SQL was originally made an ANSI standard in 1986. The ANSI 1989 standard (often called SQL-89) defines three types of interfacing to SQL within an application program:

Module Language: Uses procedures within programs. These procedures can be called by the application program and can return values to the program via parameter passing.

Embedded SQL: Uses SQL statements embedded with actual program code. This method often requires the use of a precompiled to process the SQL statements.

SQL has three major components:

The DML refer to Data Manipulation Language.
The DDL refer to Data Definition Language.
The DCL refer to Data Control Language.

SQL (Structured Query Language):

SQL is acronyms of Structured Query Language
Structured Query Language (SQL) lets you access and management of databases
American National Standards Institute standard called SQL.
SQL is a Relational type database. Also called tabular database.

Work of SQL:

SQL execute queries against a database
SQL retrieve data
SQL insert records
SQL update records
SQL delete records
SQL create new databases
SQL create new tables
SQL create stored procedures
SQL create views
SQL set permissions on tables, procedures, and views

Create data base in sql

Work of Database Management System or Use of DBMS:

Basically data base Management System refers fallowing responsibilities.

Data definition –Data structures for a database, and removing data structures from the database, and modifying the structure of existing data means create, update, delete.

Update – Inserting, modifying, and deleting data.

Retrieval – Obtaining information either for end-user queries and reports or for processing by applications.

Administration –Refer Managing all thing related to the database.

Work in SqlDatabase:

SELECT Statement : Retrieve records from a table

SELECT LIMIT Statement : Retrieve records from a table and limit results

SELECT TOP Statement : Retrieve records from a table and limit results

INSERT Statement : Insert records into a table

UPDATE Statement : Update records in a table

DELETE Statement : Delete records from a table

UNION Operator : Combine 2 result sets (removes duplicates)

UNION ALL Operator : Combine 2 result sets (includes duplicates)