What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

How do you delete duplicate rows in sql server?

0 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---

Explain logical operators in sql server?

0 Answers  

---

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

One table how may column and Primary key

3 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---

Why use “nolock” in sql server?

0 Answers  

---