Answer Posted / srividhya.s

Triggers are simply stored procedures that are executed
automatically by the database whenever
some event (usually a table update) happens.

sample:

CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be
displayed ’ :NEW.NAME);
END;

What does sqldatareader return?

917

---

What does ole stand for in excel?

1067

---

What is DataReader Object?

988

---

Why do we use sqldataadapter?

908

---

Is bulk insert faster than insert?

864

---

What is ado.net components?

901

---

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1970

---

What is the usage of the dataset object in ado.net?

919

---

What is ado connection?

898

---

Why do we need ado.net?

910

---

What is data adapter in ado.net with example?

951

---

What are all the classes that are available in System.Data Namespace?

963

---

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

950

---

Explain all the classes those are used for database connections between sql server and asp.net?

955

---

What are the Features and disadvantages of dataset

1037

---