rka9393331325 Posted September 26, 2006 Share Posted September 26, 2006 How to use a SQL Trigger. Pls give me the complete text query. Link to comment Share on other sites More sharing options...
Raj Ali Posted October 2, 2006 Share Posted October 2, 2006 How to use a SQL Trigger. Pls give me the complete text query.create trigger trigger_name on table table_namefor{[update][,][delete][,][insert]}[WITH ENCRYPTION]as sql_statementwhere trigger_name: names The triggertable:names of tables on which tge trigger has to be executedWith Encryption: Prevents other users from viewing the text of the trigger[update][,][delete][,][insert]: Keywords that specify the statements that will invoke the triggerSql_statement:Transact_SQL statements to be executed when the trigger is invokedIf You need Any other other help in triggers you can mail me Link to comment Share on other sites More sharing options...
rka9393331325 Posted October 3, 2006 Author Share Posted October 3, 2006 create trigger trigger_name on table table_namefor{[update][,][delete][,][insert]}[WITH ENCRYPTION]as sql_statementwhere trigger_name: names The triggertable:names of tables on which tge trigger has to be executedWith Encryption: Prevents other users from viewing the text of the trigger[update][,][delete][,][insert]: Keywords that specify the statements that will invoke the triggerSql_statement:Transact_SQL statements to be executed when the trigger is invokedIf You need Any other other help in triggers you can mail meThanks.What is the benefit of using triggers and when they should be used. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now