| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Creating the Audit Trigger | SQL Server 2000, SQL Server 7.0 | Intermediate /
Kazi Khalid | 23754 since
4/12/2004 2:23:29 AM |
By 4 Users
3 Excellent Ratings
|
| |
Create an audit trigger on the tables in order to record the changes to the data by the user |
| |
| |
| |
|
Determine the table from which a trigger was fired in the trigger itself | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 15350 since
7/29/2000 9:44:52 PM |
By 3 Users
|
| |
How to determine the table from which a trigger was fired in the trigger itself? This technique can be used to write a common SP that can use the table name identified thus. |
| |
| |
| |
|
Determine the type of DML operation in a trigger | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 14465 since
7/25/2000 8:37:08 PM |
By 3 Users
2 Excellent Ratings
|
| |
Determine the type of DML operation in a trigger that is coded for INSERT, UPDATE or DELETE. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 dynamic trigger | SQL Server 2000, SQL Server 7.0 | Advanced /
zpaulo carraca | 9632 since
2/11/2005 1:57:22 PM |
By 3 Users
2 Excellent Ratings
|
| |
Write business rules using conditions (T-SQL), message texts (plain text) and actions (T-SQL) and store them in a database table.
These rules will be automatically called by a general purpose trigger generated dynamically by the Software.
|
| |
| |
| |
|
Insert Trigger | SQL Server 7.0 | Beginner /
DECIS | 24352 since
1/24/2001 7:56:13 AM |
By 7 Users
5 Excellent Ratings
|
| |
Takes Newly Inserted Values and place them in another table. |
| |
| |
| |
|
Sql Tiki with Triggers | SQL Server 2000, SQL Server 7.0 | Intermediate /
Alejandro Botero Maya | 1061 since
2/25/2013 3:40:06 PM | Unrated
|
| |
This is a triki for sql
The game is played like this example:
update Tbl_Triki set Col1 = '-', Col2 = '-', Col3 = '-'
UPDATE Tbl_Triki set Col1 = 'o' where id = 2
select * from Tbl_Triki
UPDATE Tbl_Triki set Col2 = 'o' where id = 2
select * from Tbl_Triki ...(description truncated) (ScreenShot) |
| |
| |
| |
|
Table audit log | SQL Server 2000 | Intermediate /
Jesse Leon | 16877 since
7/11/2003 9:01:51 AM |
By 6 Users
2 Excellent Ratings
|
| |
This shows how you can create a trigger on a table that will show what is happening in your tables. This shows that you can log the original value before change, the new value after change, who changed it and when. This sample is based on the authors tabl ...(description truncated) |
| |
| |
| |
|
tgrPostData | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Raalnan Five | 7793 since
3/23/2004 11:26:05 PM |
By 1 Users
|
| |
Split an insertion and distribute it to seperate tables. |
| |
| |
| |
|
 Trigger to prohibit to update AddDate Field | SQL Server 2000 | Advanced /
Jairo Abraham Bernal Villanueva | 8254 since
2/20/2005 8:25:18 PM | Unrated
|
| |
In order to prohibit this, we can create a instead of trigger in the table. Tis code works fine with multiple updated rows in SQL Server 2000. Thus:
|
| |
| |
| |
|
Triggers count & order.sql | SQL Server 7.0 | Beginner /
Umachandar | 14915 since
7/13/2000 10:09:09 PM | Unrated
|
| |
determine the number of triggers & their firing order in SQL Server 7.0. |
| |
(ScreenShot)
