CODEWITHSUNDEEP
sqlsql-server
new
new

Reputation: 307

Trigger on Select

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.

Upvotes: 0

Views: 365

Answers (3)

Michael R
Michael R

Reputation: 1

Check out my proposed solution in this similar question.

"Use a VIEW and INSTEAD OF triggers to make it behave as a table and you can accomplish the equivalent of an INSTEAD OF SELECT trigger among other interesting things...."

Upvotes: 0

Azhar
Azhar

Reputation: 20680

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.

Upvotes: 0

marc_s
marc_s

Reputation: 755033

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.

Upvotes: 4

Related Questions