Answer Posted / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a ddl statement?
Which sql server is best?
What is sql server profiler trace data file?
What is conditional split?
What do you understand by a view? What does the with check option clause for a view do?
what are different types of raid configurations? : Sql server database administration
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is the size of transaction log file?
How do you migrate data from mssql server to azure?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is ssl in sql server?
What is a transact-sql statement?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain about system stored procedure?
Define self join in sql server joins?