Answer Posted / jay vardhan singh
Yes,
Trigger cannot be fired explicitly.We cannot call trigger .
It fires automatically on event.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are the different types of collation sensitivity in sql server?
Equi join and non equi join is possible with sql server?
Why union all is faster than union?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How to use subqueries with the exists operators in ms sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How do you Implement SSIS Packages in your Project?
Explain different types of locks in sql server.
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are functions in the sql server?
How to drop an existing schema in ms sql server?
Explain about local stored procedure?
when would you go for denormalization? : Sql server database administration
What is instead of dml trigger?