Categories
Sql Server

How to insert data in Sql server table

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:- […]

Categories
Sql Server

How To Rename Your SQL Server Default Instance Or Named Instance

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 […]

Categories
Sql Server

How To Install A Instance In SQL 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 […]

Categories
Sql Server

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 […]