Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

How do I start sql server agent automatically?

0 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

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,

---

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

What is scalar user-defined function?

0 Answers  

---