Month: November 2011

How to make joins in SQL Server

In database joins are used to retrieve data from two or more table based on logical relationship between these tables. A typical join specifies a forgien key from one table and its associated primary key in the other table. To

Posted in MS SQL Server Tagged with:

Creating table in SQL Server

You can create table in MS SQL Server either of the following way, •Enterprise Manager •Transact SQL (T-SQL) statement Here I will show you how to create table using T-SQL. The syntax is as below for creating table,

Posted in MS SQL Server Tagged with:

Unable to connect local server

I was on vocation and when I came back and try to start SQL server. It gives me below error. Connect to Server ———————————– Cannot connect to localhost. ———————————– ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a

Posted in MS SQL Server