How to update muliple row in single query?

0 Answers   MCN Solutions,

---

Explain about builtinadministrator?

0 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

Anyone please explain me the concept of Serialization?

3 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

Will count(column) include columns with null values in its count?

0 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

What is difference between views and stored procedures?

0 Answers  

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---