Description
SQL means "Structured Query Language". SQL is used like a language which is used to communicate with the database. Here, database means SQL SERVER.
Description
To connect with the backend and get the database from the SQL Server into the front end application, one have to use the SQL.
SQL is a Query language which have the queries.
Description
Query means a question which one want to ask database.
There are two types of queries.
Action Query
- Action Query is used to perform some operations like insert, delete, and update.
- Select Query is only used to retrieve data from the database.
Note
Refer more about SQL in the following URL. http://www.splessons.com/lesson/sql-tutorials/ Programming
Tips
To create a table in SQL, use the below syntax.
Syntax
create table table_name(column_name1 datatype, column_name2 datatype....Column_nameN datatype); Example
create table tbl_emp(Id int, Name varchar(20),Salary int);
Inserting rows into a table.
Syntax
insert into table_name values('value1','value2'.....valueN); Example
insert into tbl_emp values(1,'John','50000');
Programming
Tips
Let's take an example. Suppose one want to insert a Textbox value in a table.
Then write the query as
insert into tbl_emp values('"+txtName.Text+"');
Programming
Tips
Syntax to update the rows in a table in SQL
Syntax
update table table_name
set column_name=value
where column_name=value Example
Suppose one want to update above inserted name(John) as David
Then,
update table tbl_emp
set name='David'
where Id=1
Description
Updation in C# is same as above mentioned query. But syntax is changed.
update table tbl_emp set name='"+txtName.Text+"' where Id='"+txtId.Text+"'
Programming
Tips
To select the rows from table use the below syntax.
Syntax
select * from table_name;
OR
select column_name1, column name2..etc from table_name; Example
select * from tbl_emp;
Programming
Tips
select command is similar as in SQL.
select * from tbl_emp;