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 are the main differences between classic ado and ado.net?

1057

---

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1184

---

What is ado in agriculture?

1009

---

What is data view and variable view?

972

---

How can you add or remove rows from the datatable object of dataset?

1071

---

Explian About DataAdapters

1086

---

Explain the difference in an abstract class and an interface?

973

---

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1111

---

What are the key features of ado.net?

1271

---

What are the features of ado.net?

1112

---

How would you connect to database using .NET?

1081

---

What is read only and forward only in ado.net?

981

---

How to retrieve the user id which is provided while windows authentication?

1146

---

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

986

---

What are the pre-requisites for connection pooling?

1059

---