can anyone help me?

Question

i have a DB in sql server.. can someone help me to execute....3 triggers, 3 functions, and 3 procedure

Answer 1

Hello,

Can you please explain more detailed, what you want to do? How does the table(s) design look like (DDL statement + some sample data + required output)?

---

Olaf Helper

Blog Xing

Answer 2

What is you exact requirement.

1. Trigger - You don't need to execute Trigger, you have to understand which type of trigger it is, and when shall your trigger will fire (Insert /Update/ Delete ) of which table.

2. Function, you have to understand which type of function you have, what are all parameters you need to execute your function. look following example, this is executing scalar function.   

SELECT * FROM Sales.ufn_GetTotalSales('EastZone')

3. Procedure, you have to be aware what all the parameter you need to execute your procedure, following example is a simple SP executing with a parameter.

Exec GetTotalsales @BranchName='Pune'

---

Thanks
Manish

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.