what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

---

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

How we can refresh the view?

0 Answers  

---

What are three major types of constraints?

0 Answers  

---

What is user-defined multi-statement table-valued function?

0 Answers  

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

What is the sql case statement used for? Explain with an example?

0 Answers  

---

List few advantages of stored procedure.

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,

---