Category Archives: 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

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

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 select Distinct records from a table in Sql server

In tables some of the columns may contain duplicate values. But you want to list out the (distinct) values of a coloum in that table. The DISTINCT keyword can be used to return only distinct (different) values. First of all create a table. create table dept_test( Deptno int,dname varchar(20),loc varchar(20)) Then insert records into the table you