hi all,

Can anyone let me know how efficient is using SELECT statement inside the body of trigger?

Thanks is Advance.

I am not sure what you are asking for here? A trigger is internal functionality inside a database which can be used to either marge data into different tables or perform simple or complex data integrity constraints.

If you are looking to have records returned then i would suggest you look at stored procedures or stored functions.