Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Insert Trigger Calculation

Author  Topic 

mrock
Starting Member

23 Posts

Posted - 2004-09-23 : 16:14:24
I need a sample insert trigger (Sql Server 7.0) that will perform a calculation using fields from the inserted record, and update another field in the inserted record with that calculated value.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-23 : 16:22:41
So the examples in SQL Server Books Online didn't help you?

Tara
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-09-24 : 04:41:23
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40387

Kristen

Go to Top of Page
   

- Advertisement -