What is a pdo connection?

0 Answers  

---

Why do we use triggers?

0 Answers  

---

What is trigger point?

0 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

---

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

---

Is sql a backend?

0 Answers  

---

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---

What are the various levels of constraints?

0 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---

what is a cursor? : Sql dba

0 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---