What is join view in sql?

0 Answers  

---

What is auto increment in sql?

0 Answers  

---

What do you mean by “trigger” in sql?

0 Answers  

---

How do you optimize a stored procedure query?

0 Answers  

---

What are the differences between in and exists clause?

0 Answers  

---

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

How to make a copy values from one column to another in sql?

0 Answers  

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

---