views is the best solution for this.....
Type: Posts; User: ckarthick; Keyword(s):
views is the best solution for this.....
trigger mainly used to implement business rules, we can perform only DML operations in trigger, trigger is implicitly called by the database
table can have only one clustered index, and it can have more than one non-clustered index