TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
shashikant singh
NA
6
17.4k
Write a Trigger for update a column in sql server
Nov 16 2012 6:32 AM
I have 102 sp which modified(insert) a particuler table , but I add A new column DurationInMinutes(bigint) in that table. and these column is updated according Status means it hold timestamps(difference) between two status for example---
new record inserttime is(in first status) 11:30 for a work_orderid
and second status just like work in progress time is 11:46 for above work_orderid
then this column hold value in First Status time is bydefault =0
and in second statust this column hold value is =16 , according to work_orderid
So without changes sp , I want to write a trigger for update those column(DurationInMinutes).
Please give me a sample of trigger for do this type of work..........
Reply
Answers (
0
)
how to insert images in a database
splitting a text