The INSERT statement in Sql server is used to insert new records in a table. We can insert new records in two forms:- First:- Insert into table_name values (value1,value2,value3) Second:- Insert into table_name(coloum1,coloum2) values(value1,value2) Insert into Example:- ID Name Class Roll No 1 Jai B.A 12 2 Mohan M.A 23 4 Om B.A 2 Query:- […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
How To Rename Your SQL Server Default Instance Or Named Instance In this tutorial i will explain How To Rename Your SQL Server Default Instance Or Named Instance.Have you ever had to change the name of SQL Server. If yes, Then follow these steps to do this. Open Sql server management studio. See your server […]
How To Install A Instance In SQL Server In this tutorial i will explain you How To Install A Instance In SQL Server.SQL Server instance is a complete SQL server and you can install upto 50 instances in a SQL server 2008 and SQL server 2005 on a machine but you can have only 1 default instance. An […]
How to use AND & OR in Sql server
Both AND & OR are used to filter records on more than one condition. AND & OR AND operator displays a records if first condition and second condition is true. OR operator displays a records if either first condition or second condition is true. Example Table:- ID Name Class Roll No 1 Jai B.A 12 2 Mohan […]