Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---

What is compound operators?

0 Answers  

---

whats the maximum size of view state??

0 Answers  

---

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

Explain the different index configurations a table can have?

0 Answers  

---

What is exporting and importing utility?

0 Answers  

---

Is it safe to delete log files?

0 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---