What is table value parameters (tvp)?

0 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

How do I find the size of a sql server database?

0 Answers  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

---

What is a functions and types in sql server?

0 Answers  

---

What is the difference between set and select?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

What do you understand by a stored procedure?

0 Answers  

---

How to create indexed view?

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 is the meaning of resultset type_scroll_insensitive?

0 Answers  

---