Answer Posted / ashish sharma

create table uname
(
id int,
uname varchar(10)
)

create trigger insert_Uname
on uname
for insert
as
declare @nm varchar(10)
select @nm = uname from inserted
print @nm

so when we insert any record in the above table
the username will be get printed.

What is datatable in ado.net?

923

---

Explain sqlconnection object?

935

---

What are the steps to connect to a database?

978

---

Which ado.net object is very fast in getting data from the database?

1051

---

What is the difference in an abstract class and an interface?

952

---

What is the difference between Datareader and Dataset?

1028

---

Explain the difference between ado and ado.net?

879

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

2030

---

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1085

---

describe the dataset object in ado.net.

906

---

How can we add/remove row's in "datatable" object of "dataset"?

971

---

What are the several execute methods of ado.net?

869

---

What is ado.net components?

901

---

What is an ado connection?

919

---

Why do we need ado.net?

910

---