
October 19th, 2004, 06:35 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
2 problems with TRIGGERS in MSSQL
I need 2 triggers on MSSQL
I have 2 tables SECOND and MINUTE
In SECOND table is resived information in every second.
1. Now i need to copy in every 60 second - one row(the last row) in MINUTE table
((TRIGGER ON INSERT)if Index devide on 60 -> then put this row to MINUTE)
2. SECOND table must be <=240 rows
(TRIGGER ON INSERT) if row(SECOND) count>240 -> do insert, But last (Min(Index)of SECOND) -> DELETE)
PLEASE HELP me to Write this TRIGGERS
|