 |  |  |  |  |  |  |  |
Ms Sql 2000
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
•
•
Join Date: Mar 2004
Posts: 634
Reputation: 
Solved Threads: 7
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: 92
Reputation:
Solved Threads: 8
Junior Poster in Training
•
•
•
•
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?
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
|
Similar Threads
- 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
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
autogrowth connectingtodatabaseinuse count cursor data database datepart dbsize deadlock delete_trigger highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms mssql multiple multithreading news number permission query reporting result server services sets source sql sqlserver sqlserver2005 supercomputing tables uniqueid update view
