Answer / prabhakar

sql server 2005 is located in c:\program files\microsoft sql server\mssql1.1

Answer / phani kiran sai

Suhanya, I am pretty sure that you are eager to know
something about SQL SERVER 2K5 / 2K8 but you need to slow
down and think... is the question that you have asked really
mean anything... does it really have any meaning.. honestly
i didnt get your question.
If you are a developer and if you are looking for Query
window and if this is your question, then you will have to
login to the SQL server instance and click NEW QUERY tab
from the top menu..
if your question was about the physical location of where
actually the SQL SERVER is installed, then its already
answered by prabhakar... which happens to be the default
installation directory for SQL SERVER installation.
If your question was something else apart from what i have
understood, then do feel free to revert back... we are here
to help you guys...
Its not asking a proper question... its asking a question in
a proper way...

What is a cube? : sql server analysis services, ssas

0 Answers  

---

How to Check if table exists in sql server?

0 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

Explain time data type in sal server 2008?

0 Answers  

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

What is Left Outer Join?

2 Answers  

---

* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

What is a recursive stored procedure in sql server?

0 Answers  

---