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 sqldatareader?

885

---

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

976

---

Explain the difference between data reader and data set?

887

---

What is ado.net objects?

918

---

What are all features of ADO.Net?

943

---

What is difference between connected and disconnected architecture in ado.net?

1116

---

What is ado or jdbc?

881

---

What is oledb connection?

944

---

How to add an aggregate column?

958

---

What is the difference between dataset and datatable?

952

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

990

---

How to find the given query is optimised one or not?

928

---

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

1010

---

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

953

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2101

---