can we execute trigger normally at the desired time?

Question Posted / swapna

Answers were Sorted based on User's Feedback

can we execute trigger normally at the desired time?..

Answer / ganesh

no we can't execute triggers explicitly.
they gets executed automatically when we perform DML
operations

Is This Answer Correct ?

13 Yes

0 No

can we execute trigger normally at the desired time?..

No, it's not possible to shedule timing for a trigger.

In this situation we can shedule a job.

Is This Answer Correct ?

4 Yes

3 No

can we execute trigger normally at the desired time?..

Answer / sudhakar sakthivel

No, We can't execute automatically, If we Execute any DML
Statements on the table, The corresponding trigger will be
fired automatically.

Is This Answer Correct ?

0 Yes

0 No

More ADO.NET Interview Questions

What are major difference between classic ADO and ADO.NET?

What is row state?

Can datareader hold data from multiple tables?

What are all the different methods under sqlcommand?

What is the difference between Command and CommandBuilder object?

What is dataadapter in ado.net?

What is the namespace in which .NET has the data functionality classes?

What are the major difference between classic ADO and ADO.NET?

How to read data with the sqldatareader ?

can we have multiple datatables in a datareader ?

What are the Different layers in ADO.Net?

What is the difference in record set and dataset?

For more ADO.NET Interview Questions Click Here