What are transactions and its controls?

0 Answers  

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

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,

---

How to update values in a table with update statements in ms sql server?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

---

What do you understand by intent locks?

0 Answers  

---

What is data modeling and Reterminal integrity?

0 Answers  

---

What are statistics?

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

---

What do you mean by an execution plan? How would you view it?

0 Answers  

---

How to create a user name in a database?

0 Answers  

---