Explain how to use transactions efficiently : transact sql

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

What is mutating table error?

0 Answers  

---

What is the trigger in sql?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What is %s in sql?

0 Answers  

---

What is pseudo column ?

6 Answers   ABB,

---

Find out the 3rd highest salary?

51 Answers   BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

How do you know if a relationship is 2nf?

0 Answers  

---