حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Fire Trigger before Update in SQL Server

meenakhi

SOLVED CLOSED ACTIVE ANSWERED
User: meenakhi
Posted: on Oct 06, 2012 06:13 AM
Forum: SQL Server
Answer: 1
Views: 2883

Hello there

How to fire a triger for before update so that old values gets checked/comapred with new values if they are new than new values must be updated other wise old values

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Oct 06, 2012 06:23 AM
Report

Trigger fire only after Update. They cannot be executed before update.

Hence simply check in your stored procedure

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

Fire Trigger before Update in SQL Server

Company

Explore

Follow us

Contact Us