what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

---

What does cursor do in sql?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---

What is trigger and stored procedure in sql?

0 Answers  

---

what is 'mysqldump'? : Sql dba

0 Answers  

---

Can we alter stored procedure?

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  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

Explain the rollback statement?

0 Answers  

---