what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

What is a call statement? Explain with an example.

0 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---

what are the limitations of identity column? : Transact sql

0 Answers  

---

What is a record in a database?

0 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---

What is mutating table?

11 Answers   Saama Tech,

---

How can the performance of a trigger be improved?

0 Answers  

---