Answer / Punit Singh Malik

SQLCA (SQL Communication Area) in DB2 is an area used for communication between the application program and DB2. It contains status information about SQL statements, error messages, and other control data.

What is denormalization in a database?

1 Answers  

---

Can we write dml inside a function in sql server?

1 Answers  

---

What is rownum and rowid?

1 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

When to use inner join and left join?

1 Answers  

---

Why is theta join required?

1 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

What is the difference between join and natural join?

1 Answers  

---

How to select 10 records from a table?

1 Answers  

---

what are dynamic queries in t-sql? : Transact sql

1 Answers  

---

Is sqlexception checked or unchecked?

1 Answers  

---

How does index help in query performance?

1 Answers  

---