Answer Posted / sivasankardoss
No, Trigger cannot be fired implicitely. Only a DML
statement can invoke a trigger.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What does the on delete cascade option do?
Which is the latest version of sql server and when it is released?
What are the different types of upgrades that can be performed in sql server?
What is default constraint in ms sql server?
How data can be copied from one table to another table?
When to use null data driven subscription?
Explain different types of index?
In what three ways is the return statement used in a stored procedure?
What is bulkcopy in sql?
What is the benefit of normalization?
What is a primary index?
Write a program to fetch first 10 records from a file?
Determine how to use the inserted and deleted pseudo tables?
What is shared lock?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
