What is the difference between osql and query analyzer?

0 Answers  

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

How you can minimize the deadlock situation?

0 Answers  

---

How do you create a clustered index?

0 Answers  

---

Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

How to link tables in sql server?

0 Answers  

---

How to use user defined functions in expressions?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

How can you control the amount of free space in your index pages?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What are the recovery models in sql server 2000?

0 Answers  

---