What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

---

What command do we use to rename a database?

0 Answers  

---

Do you know what are the reporting services components?

0 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

Distinguish between commit and rollback?

0 Answers  

---

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

How to implement service broker?

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,

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

What are group functions in query statements in ms sql server?

0 Answers  

---

How to generate create function script on an existing function?

0 Answers  

---