Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of TRIGGERS are there in MS SQL Server?
- 8 Answers
- 31266 Views
- CarrizalSoft Technologies, TCS, United Healthcare, I also Faced
- E-Mail Answers
Answer Posted / anand
3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005
DDL and LOGON are used to administrator related tasks
| Is This Answer Correct ? | 33 Yes | 8 No |
Post New Answer View All Answers
List out the difference between union and union all in sql server?
What is the primary use of the model database?
How to convert numeric expression data types by assignment operations?
What is cube dimension? : sql server analysis services, ssas
Can you name some of the dml commands in sql?
Which language rdl files made of?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Which are the olap features?
Differentiate between sql temp table vs table variable?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Do you know the policy based administration feature of sql server 2008?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Can truncate be rolled back?
What is difference between views and tables?
Tell me about builtinadministrator?
