�ݺ�ߣ

SQL-Create tableCreate table table_name(column_name1 datatype, column_name2 datatype……)Eg:create table example (id int ,name varchar(10),address varchar(10))Msg:Command(s) completed successfully.

SQL-Insert ValuesInsert into table_name(column1,column2,…..)values(values1,values2,…)Eg:insert into example (id,name,address) values(123,'xxxx','yyyyy')Msg:(1 row(s) affected)

SQL-Select Commandselect *from exampleId name address123 xxxxyyyyy456 jjjjrrrr456 iiiinnnn567 eeeeffff

SQL-Alter CommandAlter table table_name add or drop column_namedatatypeEg: alter table example add mobilenointMsg: Command(s) completed successfully.Id name address mobileno123 xxxxyyyyy NULL456 jjjjrrrr NULL888 iiiinnnn NULL567 eeeeffff NULL

SQL-Update CommandUpdate table_name set column_name=new value where column_name=any valueEg: Update example set id=888 where name='iiii‘Msg: (1 row(s) affected)Id name address123 xxxxyyyyy456 jjjjrrrr888 iiiinnnn567 eeeeffff

SQL-Delete CommandDelete table_name where conditionEg: delete example where id=888Msg: (1 row(s) affected)Id name address mobileno123 xxxxyyyyy NULL456 jjjjrrrr NULL567 eeeeffff NULL

SQL-Drop CommandDrop table table_nameEg: drop table exampleMsg:Command(s) completed successfully.

SQL-Primary Key & Foreign Key CREATE TABLE table_name (column1 datatype null/not null, column2 datatype null/not null,...CONSTRAINT constraint_namePRIMARY KEY (column1, column2, . column_n));CREATE TABLE table_name��(column1 datatype,�� column2 datatype,��column3 datatype,��Primary Key (column_any),��Foreign Key (Column_any) references Table_any(datatype));

SQL-Primary Key & foreign Keycreate table example (id intprimary key,namevarchar(10),address varchar(10))A��primary key��is used to unique and Not Null identify each row in the table.create table example2 (salary int,expamountint, id int references example(id))A foreign key��is a referential constraint between two tables.��

SQL-Primary Key & Foreign Key Id name address 123 rrrrtttt369 klkliooo456 iiiihhhh7889 wswswewwSalary expamount id10000 4235 788912369 8526 45612369 865 45665894 12589 123Example (primary Key tale)Example2 (Foreign Key tale)

SQL-DISTINCTselect distinct address from exaddressioioklkkyuyu

SQL-Primary Key & Foreign Key select name,address,salary from example e,example2 e2 where e.id=e2.idO/PName address salarywswsweww 10000iiiihhhh 12369iiiihhhh 12369rrrrtttt 65894

SQL-BETWEEN & COUNTSELECT "column_name“ FROM "table_name"WHERE "column_name" BETWEEN 'value1' AND 'value2‘select id from ex where id between 100 and 500ID123456SELECT COUNT("column_name") FROM "table_name“select count(id)'No Of Records' from exNo Of Records4

SQL-Connection Stringstring strcon = "Data Source=172.16.0.1;Initial Catalog=BatchThree;User ID=magnum;Password=Magnum";SqlConnectionsqlcon = new SqlConnection(strcon);sqlcon.Open();stringstrsql = "insert into datab values ('" + txtmarks1.Text + "','" + txtmarks2.Text + "','" + txtmarks3.Text + "','" + txtname.Text + "')";SqlCommandcmd = new SqlCommand(strsql, sqlcon);cmd.CommandType = CommandType.Text;cmd.ExecuteNonQuery();sqlcon.Close();

SQL-Stored Procedurecreate procedure proexample(@id int,@namevarchar(10),@address varchar(10)) as insert into example(id,name,address) values (@id,@name,@address)Command(s) completed successfully.exec proexample 666,'hghg','yuyu’(1 row(s) affected)

SQL-Stored Procedureselect *from exampleId name address123 rrrrtttt369 klkliooo456 iiiihhhh666 hghgyuyu7889 wswsweww

SQL-JOINSSQL joins��are used to query data from two or more tables, based on a relationship between certain columns in these tablesInner JoinLeft JoinRight JoinFull Join

SQL-INNER JOINThe INNER JOIN keyword return rows when there is at least one match in both tables.SELECT column_name(s)FROM table_name1INNER JOIN table_name2ON table_name1.column_name=table_name2.column_name

SQL-INNER JOINselect name,address,salary from example inner join example2 on example.id=example2.id order by nameName address salaryiiiihhhh 12369iiiihhhh 12369rrrrtttt 65894Wswsweww 10000

SQL-LEFT JOINThe LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2)SELECT column_name(s)FROM table_name1LEFT JOIN table_name2ON table_name1.column_name=table_name2.column_name

SQL_LEFT JOINselect name,address,salary from example left join example2 on example.id=example2.id order by nameName address salaryhghgyuyu NULLiiiihhhh 12369iiiihhhh 12369klkliooo NULLrrrrtttt 65894wswsweww 10000

SQL-RIGHT JOINThe RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1)SELECT column_name(s)FROM table_name1RIGHT JOIN table_name2ON table_name1.column_name=table_name2.column_name

SQL_RIGHT JOINselect name,address,salary from example right join example2 on example.id=example2.id order by nameName address salaryiiiihhhh 12369iiiihhhh 12369rrrrtttt 65894wswsweww 10000

SQL-FULL JOINThe FULL JOIN keyword return rows when there is a match in one of the tables.SELECT column_name(s)FROM table_name1FULL JOIN table_name2ON table_name1.column_name=table_name2.column_name

SQL-FULL JOINselect name,address,salary from example full join example2 on example.id=example2.id order by nameName address salaryhghgyuyu NULLiiiihhhh 12369iiiihhhh 12369klkliooo NULLrrrrtttt 65894wswsweww 10000

SQL-VIEWviews can be considered as virtual tables and it physically stores the data. A view also has a set of definitions,and it does not physically store the data.The syntax for creating a view is as follows: CREATE VIEW "VIEW_NAME" AS "SQL Statement"

SQL-VIEWcreate view vex as select *from exselect *from vexid name address123 pop yuyu456 huh ioioexareredrop view vex

SQL-DISTINCTThe��SELECT UNIQUE��term is an Oracle-only SQL statement. It is equivalent to��SELECT DISTINCT.��SyntaX:SELECT DISTINCT "column_name"FROM "table_name“Eg: select *from exId name address123 pop yuyu456 huh ioio856 exaklkk856 exaklkk

SQL-IN & LIKESELECT "column_name“ FROM "table_name"WHERE "column_name" IN ('value1', 'value2', ...)select name,address from ex where id in(456)name addresshuh ioioSELECT "column_name“ FROM "table_name"WHERE "column_name" LIKE {PATTERN}select name,address from ex where id like(456)name addressHuh ioio

�ݺ�ߣ

Sql

Recommended

More Related Content

What's hot (14)

Viewers also liked (14)

Similar to Sql (20)

Recently uploaded (20)

Sql