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 a serialized object?

538

---

What is ado.net objects?

523

---

What is the maximum pool size in ado.net connection string?

502

---

What are the advantages using ado.net?

539

---

How can we perform transactions in .net?

549

---

---

What is ado.net tutorial?

505

---

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

557

---

What are the core objects of ADO.NET?

588

---

How do I delete a row from a DataTable?

597

---

What are the benefits of using ado.net?

518

---

What are the Features of a dataset

666

---

What is difference in record set and dataset?

538

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

526

---

How do you implement locking concept for dataset?

545

---

What does datareader object do?

543

---