Fetching data from two or more tables(Joining of tables)

Selecting data from two or more tables(Joining of tables) Hello Friends, today we will learn how to select data(records) from more than one table. For this purpose we will use joining of tables. Joining simply join one or two or more than two tables by some conditions as per need. One there is a joining between one

insert, delete and update queries using mssql server

Insert Query insert into table_name(column1,column2,column3,column4) values(value1,value2,value3,value4) We can also use design view to insert values into table. If you dont know how to create a table please follow the previous post create a table in mssql server . Just Right click on the Table_name in which you need to insert the table and select open table. Now put the