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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-19 : 15:33:33
|
David writes "Hi, I have started working on a SQL 6.5 project, and I got a word from my boss that he heard from somebody else that there is a automatic datestamp(including time) of when a record is modified. Having worked on database for only a year(in SQL 7.0), I have never come across this. I only know that a timestamp is automatically generated, but it has nothing to to with dates or anything. The project involves making a stored procedure to delete a record(which has been marked for delete) which has a datestamp of older than 30 days. Is there a automatic datestamp? or do I have to include the date fields manaully?
Also related, I am working on another stored procedure which is to cascade-mark for delete. Is is wiser to use stored procedures instead of triggers? There are tables with 1-n, n-n, n-1 relationships. I heard that if there is a n-1(Foreign-Key to Primary-Key, I think) table, triggers cannot be used. Is it true? Thanks!
- sql novice - david"
|
|
|
|
|
|
Re: Datestamps.