Where is my database stored on the hard disk in ms sql server?

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

0 Answers  

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

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 happens if an integer is too big for int date type?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

What are scalar functions?

0 Answers  

---