Trigger on Select

Question

I want to return different results to user when using Select because it returns wrong value and i cant use view or something else because its third party appliction.

I want to make instead of his select perform another select trigger or any thing else.

Answer 1

SQL Server doesn't have the concept of a INSTEAD OF SELECT (nor an AFTER SELECT) trigger - you will need to find another way to achieve this.

Answer 2

Actually SQl server Supports Trigger on an INSERT, UPDATE, or DELETE statement, there is no concept of trigger on Select statement. You can write stored procedure to implement you logic or you have to find some other way.