Answer Posted / lakshmibabu

Address varible is called pointer

List some major differences between triggers and stored procedures?

917

---

How can I change procedure name in sql server?

1045

---

What are the difference between primary keys and foreign keys?

964

---

Describe the left outer join & right outer join. : sql server database administration

992

---

How to remove duplicate rows from table except one?

1004

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1024

---

What is repeatable read?

1011

---

How to write character string constants or literals in ms sql server?

1015

---

What is the use of group by clause?

939

---

What are the steps you must follow to hide sql server instances?

972

---

When I delete any data from a table, does the sql server reduce the size of that table?

1008

---

Explain can SSRS reports Cache results?

158

---

What is the difference between a unique key and primary key?

945

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1040

---

What is the contrast between sql and pl/sql?

1140

---