How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

How to find the second highest salary of an employee?

0 Answers  

---

Do you know what is fill factor and pad index?

0 Answers  

---

How to rebuild all indexes on a single table?

0 Answers  

---

What is the maximum number of index per table?

0 Answers  

---

What is a primary index?

0 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

how to change column into row in sql

4 Answers   ESS,

---

What is full outer join in sql server joins?

0 Answers  

---

How to download and install the scaled-down database adventureworkslt?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---