Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

What is the difference between mysql and sql server?

0 Answers  

---

How to copy the tables, schema and views from one sql server to another?

0 Answers  

---

How many joins in sql server?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

how can i lock the column in the table

2 Answers   Accenture,

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

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,

---

What do you understand by user-defined function in the sql server?

0 Answers  

---