The question is: "how many types of DML triggers in present?" So the answer should be : 3 types of DML triggers: CLR Triggers, AFTER Triggers,INSTEAD OF Triggers.

Cheers,

Sur...

There are 3 types of DML triggers: CLR Triggers, AFTER Triggers,INSTEAD OF Triggers. Answer given is wrong in the post.

Where is the article?

I could not able to see it. 🙁

I think the it is missing.

Regards,

Sur

Please give me my points, I gave the correct answer 🙂 but there it is showing as wrong 🙁

Such kind of errors can be avoided if the Answer given by...

I think the answer is RANK() but the correct answer mentioned is ROW_NUMBER.

How it could be?

Can anyone explain it?

Look below:

Correct answer:

ROW_NUMBER

Explanation:

RANK() is the correct function as it will...

Hi,

I believe this will help you in this regard....

http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/

http://www.developer.com/db/article.php/3547866

Cheers,

Sur...

I think this will help you....

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

See the "The Upgrade Mechanism" section in this article

Cheers,

Sur...

"I have always wanted the best for myself, so that I can...