Can we use ddl statements in stored procedure?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

What is the execution plan in sql?

0 Answers  

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

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

6 Answers   DELL, HCL, Oracle,

---

why not null constraint showing its constraint type as 'c'

1 Answers  

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

What is sql comments?

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

who introduced sql?

0 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---