Re: Ms Sql 2000

•

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 422,560 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 4,598 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.

Join our community!

Please support our MS SQL advertiser: Programming Forums

Ms Sql 2000

•

Join Date: May 2004

Location: Portland, OR, USA

Posts: 51

Reputation: gusano79 is on a distinguished road

Rep Power: 5

Solved Threads: 1

gusano79

Offline

Junior Poster in Training

Re: Ms Sql 2000

Jun 15th, 2004

•

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

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 422,560

Users Online Now: 4,598

Active IRC Users: 28

Forum Threads: 135,381

Forum Posts: 688,767

Code Snippets: 901

Blogs: 149

Blog Entries: 2,280

Directory Links: 577

DaniWeb Home > Forums > Web Development > Databases > MS SQL > Ms Sql 2000

Re: Ms Sql 2000

Ms Sql 2000

Re: Ms Sql 2000