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 the full form of ado?

1004

---

Which is better entity framework or ado.net?

1037

---

What is ado.net tutorial?

922

---

Which is better ole db or odbc?

899

---

What is acid in ado.net?

1023

---

What are the essential features of ado.net?

947

---

What are the uses of Stored Procedure?

1061

---

What is the advantage of ado.net?

1012

---

What is basic use of data view?

997

---

What is difference between datagridview and datagrid control in winforms?

1016

---

What are the different methods available under the sqlcommand class to access the data?

1036

---

What is ado net stands for?

964

---

How to connect and retrieve data from database using dataset

1037

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1003

---

What two types of data providers does ADO.NET supply? What determines which one you should use?

986

---