What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

Does index speed up select statements?

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,

---

What is de-normalization and when do you do it?

3 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

---