5 Reputation Points
Ranked #3K
- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
100% Quality Score
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
0 Endorsements
Ranked #44.2K
Hi, I have a simple SQL query [CODE=sql]update testcourselog set grade='a' where statusid=4[/CODE] It updates 114 records I am trying to write a trigger that will change a flag to 1 for all record updated by the query. [CODE=sql]USE [online] GO /****** Object: Trigger [dbo].[gl_courselog_iscounted_update] Script Date: 12/10/2007 16:49:32 ******/ … |