Hi this is my first post.. i am really getting confused regarding trigger.. please correct me if am wrong there is no way we can get output from trigger into our web forms.. right ?? So my question is what is the main use of trigger in a application and also if possible please tell me can i use in my online shopping system if its possible please clarify this using real world example. I know basic of that we can bind trigger or register trigger with some command like insert delete and so on. Is it only use for testing purpose only ?? Please i am not able to find any answer on google please help me out with this.
Hi Prashant,
ReplyDeleteAs per my knowledge Consider a case where you have to maintain the history of the table to for that you have to create the trigger suppose some body placed an order and after some time they modified it so you need to track the history for future references this is the one eg i think of another one is if you want to make sure in future if any issue occurred at the programming level and you want to make sure you data is never be in inconsistent state so you have to use the trigger i suppose you know the type of the triggers.
If you have any other query please be my guest.
ok i get that.. but how can we test that.. i mean is it for DBA only.. and how a customer can change its oder details.. are refering to some sql injection or hacking part.. or some DBA try to do that.. so what i am not getting is.. its beneficial for whome i mean who will see the details..is there any involvement for asp.net programmer please if possible clarify my doubts..
ReplyDeleteThanks for answering