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
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How to remove duplicate rows from table except one?
Do you know how to send email from database?
what kind of lan types do you know? : Sql server database administration
Explain where clause?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is logon trigger?
Does partitioning help performance?
List the different index configurations possible for a table?
How many columns can we include on clustered index ?
What is the synonym of join?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to use copy and concatenate commands in SQL?
Write a program using SQL queries to find a unique entry in a table.
Where is my database stored on the hard disk in ms sql server?
