Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

---

What is subquery in sql?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

List all the types of user-defined functions?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---

What command is used to create a database in the sql server and how?

0 Answers  

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

What is the use of stored procedure?

0 Answers  

---

What is cursors? And what are the different types of cursor?

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,

---