•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 373,936 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,802 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 6859 | Replies: 2
 |
•
•
Join Date: Mar 2004
Location: Brisbane
Posts: 632
Reputation: 
Rep Power: 7
Solved Threads: 6
Practically a Master Poster
I need to create a date updated field for ms sql 2000. The current trigger I have only works for the insertion of data and it is "(getdate())" is there one that I can use for insertion and update of fields?
Ta,
Slade
Ta,
Slade
Formerly known as Slade.
•
•
Join Date: May 2004
Posts: 43
Reputation:
Rep Power: 5
Solved Threads: 1
Light Poster
•
•
•
•
Originally Posted by slade
I need to create a date updated field for ms sql 2000. The current trigger I have only works for the insertion of data and it is "(getdate())" is there one that I can use for insertion and update of fields?
You can write a trigger that fires on both insert and update:
CREATE TRIGGER <trigger_name>
ON <table_name>
FOR INSERT, UPDATE
AS
<trigger_body>
Here's the T-SQL reference page:
http://msdn.microsoft.com/library/de...eate2_7eeq.asp
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- help with paging in sql 2000 (MS SQL)
- Applying SSL certificate to SQL 2000 (MS SQL)
- Coldfusion use SQL 2000 (ColdFusion)
- In which (really) important ways is SQL 2000 better than Access 2003? (MS SQL)
- VB and MS-sql 2000 data navigation (Visual Basic 4 / 5 / 6)
Other Threads in the MS SQL Forum
- Previous Thread: I need an exampls program in java to store image datatype in ms-sql
- Next Thread: SQL access via Dreamweaver 2004 MX
