Introduction To SQL Server

In previous post we explain some How to add captcha to web form in asp.net , How to Add splash in window form and most popular post How to make an .exe file of window based project with full of screenshot that relief from confusion
 In this tutorial we will explain some term about SQL.
First of all , what is sql ?

What is SQL ?


Sql stand for structured query language used to access the data and manipulate operation on data like insertion,deletion, updation and retrieve the data from the database. It is usually used as a backend for different application to store data of application that is used by front end. 

Note-SQL is an ANSI Standard.(Ansi stand for American National Standards Institute)


What we can do With SQL?

There are many operation that we can perform with  SQL on the user data. Some of them are given below:-

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

Using SQL in Your Web Site

To build a web site that shows some data from a database and take data from front user , we will need the following:-

• An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
• A server-side scripting language, like PHP or ASP
• SQL
• HTML / CSS

Version :- 

There are some SQL Server that are mostly used

• SQL Server 2000
• SQL Server 2005
• SQL Server 2008
• SQL Server 2010
• SQL Server 2012

Notice : Now Please click on the below or right hand side Adds .